In the Excel spreadsheet \"Dinner\", you will find 28 observations on the amount
ID: 3206401 • Letter: I
Question
In the Excel spreadsheet "Dinner", you will find 28 observations on the amount spent for dinner for four in downtown Chicago on a Friday night. Use this data for the next 8 questions.
Calculate the mean to the nearest hundredth:
Calculate the Median:
Calculate the interquartile range
Calculate the sample standard deviation:
Calculate the Range
How many bins would Sturge's Rule Suggest?
Create a histogram (using appropriate bins) and describe its shape (no need to include histogram)
Are there any outliers in this dataset? If yes, what are they?
Amount Paid for Dinner for Four Persons in Downtown Chicago (n = 28) Amount Paid 95 In compact block format: 103 95 103 109 170 114 113 107 109 124 105 80 104 84 176 115 170 69 95 134 108 61 160 128 114 68 95 61 150 52 87 136 113 107 124 105 80 104 84 176 115 69 95 134 108 61 160 128 68 95 61 150 52 87 136Explanation / Answer
Answers:
Calculate the mean to the nearest hundredth:
Mean = 107.25
Calculate the Median:
Median = 106
Calculate the inter-quartile range
Inter-quartile range = Q3 – Q1
First Quartile Q1 = 84
Third Quartile Q3 = 128
Inter-quartile range = 128 – 84 = 44
Inter-quartile range = 44
Calculate the sample standard deviation:
Sample Standard deviation = 32.30712
Calculate the Range
Range = Maximum – minimum
Maximum = 176
Minimum = 52
Range = 176 – 52 = 124
Range = 124
How many bins would Sturge's Rule Suggest?
The Sturge’s rule is given as below:
K = 1 + 3.322*log(n)
Where, K is the number of classes and n is the size of the data
We are given n = 28
K = 1 + 3.322*log(28)
K = 5.80746
K = 6 bins approximately
Create a histogram (using appropriate bins) and describe its shape (no need to include histogram)
From the histogram for given data, it is observed that the data follows approximate normal distribution or bell shaped curve.
Are there any outliers in this dataset? If yes, what are they?
There are no outliers in this dataset.
Output for reference:
Five-Number Summary
Minimum
52
First Quartile
84
Median
106
Third Quartile
128
Maximum
176
Descriptive Summary
Amount Paid
Mean
107.25
Median
106
Mode
95
Minimum
52
Maximum
176
Range
124
Variance
1043.7500
Standard Deviation
32.3071
Coeff. of Variation
30.12%
Skewness
0.3841
Kurtosis
-0.2024
Count
28
Standard Error
6.1055
Five-Number Summary
Minimum
52
First Quartile
84
Median
106
Third Quartile
128
Maximum
176