Call / Whatsapp

# Microsoft Excel

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.

## Price: £ 129

100% Plagiarism Free & Custom Written, Tailored to your instructions