Statistics help Ashford University BUS308week4 assignment

Ashford 5: – Week 4 – Assignment

 

Problem Set: Week Four
Complete the problems below and submit your work in one Word document.  Be sure to show all of your work and clearly label all calculations.  Calculations completed in Excel must be copied and pasted into a single Word document.  No Excel documents will be graded. TIP: For help copying and pasting information from Excel to Word go to http://office.microsoft.com/en-us/word-help/copy-excel-data-or-charts-to-word-HP010198874.aspx or watch the “Excel Tips – Tip#48: Copy from Excel to Word” found in Week One Recommended Resources.

 

1. Problem One The manager of a catering company is using the number of people in the party to predict the cost of the drinks that are required for the event. The following are the data for 12 recently catered events:

 

112242143031536418385206561644714368133091839101976112080122285

Event	Number of People	Cost of Drinks

 

1. Complete the calculations below using this data.  Show all of your work and clearly label each of your calculations.   

Provide a scatterplot Calculate a linear regression Calculate the residuals Calculate the correlation between the two variables Calculate the mean, median, and standard deviation of the number of people and cost of drinks

 

For additional assistance with these calculations reference the Recommended Materials for Week Four.  

 

1. Problem Two You are a real estate agent and you are trying to predict home prices for your clients that want to list their house for sale. You have a very small city without much data. You will need to use the data that you have available for the past year on homes that have been sold.

 

1

2

3

4

5

5

3

3

4

5

5

4

2

1

Bedrooms	Square Footage	Bathrooms	Price
1500	125,000
1800	148,000
4000	250,000
2100	160,000
2300	240,000
3800	245,000
1900	155,000

 

1. Complete the calculations below using this data.  Show all of your work and clearly label each of your calculations.     Conduct a multiple regression analysis to predict home prices. In your analysis complete the following:

Calculate the multiple regression analysis and report your data. Determine the list price for your client’s home if it has three bedrooms, three bathrooms, and 1900 square footage. Provide your analysis and show all of your calculations.

 

For additional assistance with these calculations reference the Recommended Materials for Week Four. Copy and paste your calculations for the two problems from Excel to Word and submit one Word document with your clearly labeled calculations and interpretations.

 

 NEED THIS AS SOON AS POSSIBLE