Question

The following data give the weekly amounts spent on groceries for a sample of 45 households. See Attached Excel Spread Sheet

$271	$363	$159	$76	$227	$337	$295	$319	$250
279	205	279	266	199	177	162	232	303
192	181	321	309	246	278	50	41	335
116	100	151	240	474	297	170	188	320
429	294	570	342	279	235	434	123	325

Use formulas from the text or notes or the Excel Commands for the descriptive statistics:

a.    Open excel insert and sort the data.

b.    From the menu bar, select Data and then Data Analysis. Select Descriptive Statistics and then click OK.

c.    For the Input Range, type C1:C181, indicate that the data are grouped by column and that the labels are in the first row. Click on Output Range, indicate that the output should go in G1 (or any place you wish), click on Summary statistics, and then click OK.

a.    How many classes would you recommend?

b.    What class interval would you suggest?

c.    What would you recommend as the lower limit of the first class?

d.    Organize the data into a frequency distribution.

e.    Create a bar chart of the frequency distribution

f.     Calculate:

Mean

Mode

Median

Range

Standard Deviation

Skewnes

What percentage of the sales is within + one standard deviation

g.    Explain the results of this analysis

Answer 1

Hello Sir/Mam

We are most delighted to answer, but I'ld request you to please ask atmost 1 question or 4 subparts per post.

Your cooperation is highly appreciated. Thanks!

I would suggest :

(a) I would recommend 5 classes.

(b) Class intervals I recommend are (40,146), (146,252), (252,358), (358, 464), (464,570).

(c) Well, its a subjective matter, but for the sake of simplicity, I would suggest 40 to be lower limit of first class.

(d) Frequency Distribution :

Lower Limit	Upper Limit	Frequency(f)
40	146	6
146	252	16
252	358	18
358	464	3
464	570	2

(e) Chart of Frequency Distribution

I would request you to create a new post for remaining parts.

Thanks for your cooperation.

I hope this solves your doubt.

Do give a thumbs up if you find this helpful.