Statistics in economy using excell

Statistics for Economics and Business

Third Excel Assignment

Each of the following uses a procedure found in the PHStat menu, under Confidence Intervals or

Sample Size. Each relies on the data in your Housing and Donations datafile.

Your work should be submitted in just ONE Excel file. Try to move all the relevan

t worksheets

to the left so I can easily find them.

Contact Dr. Rose if you have any trouble with this.

A.

Using PHStat/Excel (instructions on p. 268 of the textbook), estimate the population mean

level of annual charitabl

e donations at the 95% confidence level. Remember: you do NOT

know what the standard deviation of the population of donations is. (5 points)

è

If PHStat does not function properly on your computer, you can use the COMPUTE

worksheet in the

CIE sigma unknow

n

workbook and follow the directions on p. 268.

The

workbook is available through the link on the course Moodle page. You may have already

downloaded the file if you used workbooks on previous Excel assignments.

A.

Using PHStat/Excel (instructions on p. 26

9 of the textbook), estimate the population

proportion of all respondents who think their housing situation is “Comfortable and Safe” at

the 99% confidence level. (5 points)

è

If PHStat does not function properly on your computer, you can use the COMPUTE

worksheet in the

CIE Proportion

workbook and follow the directions on p. 269.

The workbook is available through the link on the course Moodle page.

You may have

already downloaded the file if you used workbooks on previous Excel assignments.

B.

If we were

to conduct a survey to determine the mean annual housing expenses for ALL

households in the US, how large a sample of cities should we take if we want the point

estimate (sample mean) to be within $1000 of the true population mean, at the 99%

confidence l

evel? Use PHStat/Excel to determine this sample size. (5 points)

è

If PHStat does not function properly on your computer, you can use the COMPUTE

worksheet in the

Sample Size Mean

workbook and follow the directions on p. 269.

The workbook is available thro

ugh the link on the course Moodle page. You may have

already downloaded the file if you used workbooks on previous Excel assignments.

Statistics for Economics and Business

Third Excel Assignment

Each of the following uses a procedure found in the PHStat menu, under Confidence Intervals or

Sample Size. Each relies on the data in your Housing and Donations datafile.

Your work should be submitted in just ONE Excel file. Try to move all the relevant worksheets

to the left so I can easily find them. Contact Dr. Rose if you have any trouble with this.

A. Using PHStat/Excel (instructions on p. 268 of the textbook), estimate the population mean

level of annual charitable donations at the 95% confidence level. Remember: you do NOT

know what the standard deviation of the population of donations is. (5 points)

If PHStat does not function properly on your computer, you can use the COMPUTE

worksheet in the CIE sigma unknown workbook and follow the directions on p. 268. The

workbook is available through the link on the course Moodle page. You may have already

downloaded the file if you used workbooks on previous Excel assignments.

A. Using PHStat/Excel (instructions on p. 269 of the textbook), estimate the population

proportion of all respondents who think their housing situation is “Comfortable and Safe” at

the 99% confidence level. (5 points)

If PHStat does not function properly on your computer, you can use the COMPUTE

worksheet in the CIE Proportion workbook and follow the directions on p. 269.

The workbook is available through the link on the course Moodle page. You may have

already downloaded the file if you used workbooks on previous Excel assignments.

B. If we were to conduct a survey to determine the mean annual housing expenses for ALL

households in the US, how large a sample of cities should we take if we want the point

estimate (sample mean) to be within $1000 of the true population mean, at the 99%

confidence level? Use PHStat/Excel to determine this sample size. (5 points)

If PHStat does not function properly on your computer, you can use the COMPUTE

worksheet in the Sample Size Mean workbook and follow the directions on p. 269.

The workbook is available through the link on the course Moodle page. You may have

already downloaded the file if you used workbooks on previous Excel assignments.