# Microsoft Excel

05 / 03 / 2018 Assignment

This paper circulates around the core theme of Microsoft Excel together with its essential aspects. It has been reviewed and purchased by the majority of students thus, this paper is rated 4.8 out of 5 points by the students. In addition to this, the price of this paper commences from £ 129. To get this paper written from the scratch, order this assignment now. 100% confidential, 100% plagiarism-free.

Question 1    4 Marks
(a)    List all the values in a table and then construct a stem-and-leaf display for the data.    1 mark
(b)    Construct a relative frequency histogram for these data with equal class widths, the first class being “\$4 to less than \$6”.                                 1 mark
(c)    Briefly describe what the histogram and the stem-and-leaf display tell you about the data. What effects would there be if the class width is doubled, which means the first class will be “\$4 to less than \$8”?                                    1 mark
(d)    What proportion of stock prices were above \$10?                    1 mark
(a)    Compute the mean, median, first quartile, and third quartile for each capital city (with only the data provided for that city, do not add/delete values for any new/given suburb of question 2) using the exact position, (n+1)f, where n is the number of observations and f the relevant fraction for the quartile.    1 mark
(b)    Compute the standard deviation, range and coefficient of variation from the sample data for each city.    1 mark
(c)    Draw a box and whisker plot for the median weekly rents of each city and put them side by side on the same scale so that the prices can be compared.       1mark
(d)    Compare the box plots and comment on the distribution of the data.

### 100% Plagiarism Free & Custom Written

International House, 12 Constance Street, London, United Kingdom,
E16 2DQ

Company # 11483120

## STILL NOT CONVINCED?

We've produced some samples of what you can expect from our Academic Writing Service - these are created by our writers to show you the kind of high-quality work you'll receive. Take a look for yourself!

View Our Samples

## Benefits You Get

• Free Turnitin Report
• Unlimited Revisions
• Installment Plan
• Plagiarism Free Guarantee
• 100% Confidentiality
• 100% Satisfaction Guarantee
• 100% Money-Back Guarantee
• On-Time Delivery Guarantee

+44 7340 9595 39
+44 20 3239 6980
[email protected]
AKOSZTEC “International House, 12 Constance Street, London, United Kingdom, E16 2DQ”

Hire Researcher
Rated 4.7/5 based on 8956 Reviews

## Supporting Pages

FLAT 25% OFF ON EVERY ORDER. Use "FLAT25" as your promo code during checkout