Chat with us, powered by LiveChat Statistics help Ashford University BUS308week4 assignment - Wridemy

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:

 

Event

Number of People

Cost of Drinks

1

12

24

2

14

30

3

15

36

4

18

38

5

20

65

6

16

44

7

14

36

8

13

30

9

18

39

10

19

76

11

20

80

12

22

85

 


  1. Complete the calculations below using this data.  Show all of your work and clearly label each of your calculations.   
    1. Provide a scatterplot
    2. Calculate a linear regression
    3. Calculate the residuals
    4. Calculate the correlation between the two variables
    5. 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.

 

Bedrooms

Square Footage

Bathrooms

Price

1

1500

2

125,000

3

1800

4

148,000

5

4000

5

250,000

3

2100

3

160,000

4

2300

5

240,000

5

3800

4

245,000

2

1900

1

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:

    1. Calculate the multiple regression analysis and report your data.
    2. 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

 

Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.

Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.

Do you need an answer to this or any other questions?

About Wridemy

We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.

How It Works

To make an Order you only need to click on “Place Order” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.

Are there Discounts?

All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.

Hire a tutor today CLICK HERE to make your first order