Business Finance Homework Help

I have attached the file needed and also an example of how the final draft has to be. Please the final answer has to be like the PDF example I sent you just with different numbers.

Use Garbage.xls file which consists of data from 60 fictional homes on Carson St. It includes variables regarding the household size, the pounds of each type of garbage disposed in a week, the total weight of their garbage each week, and whether or not the household recycles.

• ASSIGNED PROBLEM 1: First compute the mean total weight and standard deviation of the garbage disposed each week by the sample; use the Descriptive_Statistics.xls file if needed. Then compute the 95% confidence interval of the mean total garbage disposed of in a week on Carson St. Describe your findings.
• ASSIGNED PROBLEM 2: First compute the proportion of homes in the sample that recycle. Then compute the 95% confidence interval of the proportion of homes on Carson St. that recycle. Describe your findings.
• ASSIGNED PROBLEM 3: You wish to learn the average number of pounds of garbage disposed of in a week by the people on Carson St. within 2 pounds at 95% confidence. Using the standard deviation from problem 1 as an estimate, how large of a sample should you get?
• ASSIGNED PROBLEM 4: You wish to learn the proportion of homes on Carson St. that recycle within 10% and with 99% confidence. How large of a sample should you get?

Expectations: Copy & paste the Excel displays into a Word file if you can. Upload the Word file (or the Excel files) for credit. Comments in which you describe your findings should be included with each display. APA formatting is not required for weekly assignments but adhere to the rules of written English in your punctuation, grammar and spelling.