Scatter Diagram Between Fat And Calories Statistics Assignment

User Generated

Ebovafba64

Other

Description

For Assignment 7, there is a PDF with the instructions and there is the excel spread sheet with data needed.


Assignment 2

  1. Find the Descriptive Statistics for both Fat and Calories.
  2. Construct a Scatter Diagram between Fat and Calories.
  3. Find the Covariance and Coefficient of Correlation between Fat and Calories.
  4. Explain your finds in part 2 and 3.

Unformatted Attachment Preview

Broker 1 2 3 4 5 6 7 8 9 10 11 12 Clients (X) Sales (Y) 27 52 11 37 42 64 33 55 15 29 15 34 25 58 36 59 28 44 30 48 17 31 22 38 Assignment 07 Each question worth 8 points The managers of a brokerage firm are interested in finding out if the number of new clients a broker brings into the firm affects the sales generated by the broker. They sample 12 brokers and determine the number of new clients they have enrolled in the last year and their sales amounts in thousands of dollars. These data are presented in the table that follows. Broker 1 2 3 4 5 6 7 8 9 10 11 12 Clients (X) 27 11 42 33 15 15 25 36 28 30 17 22 Sales (Y) 52 37 64 55 29 34 58 59 44 48 31 38 1. Generate a scatter plot between the number of new clients and sales using Excel. 2. Run a regression of the number of new clients on sales, and report the results using Excel. 3. Find the simple linear regression equation. 4. Interpret the estimated coefficients (b0 and b1). 5. What is the meaning of the regression R2? 6. What is the prediction for the Sales for a Broker who brings 44 new clients? 7. What should the null hypothesis be for the intercept (b0)? Calculate the relevant t-statistic and carry out the hypothesis test at the 5% level. 8. What should the null hypothesis be for the slope (b1)? Calculate the relevant tstatistic and carry out the hypothesis test at the 5% level. 9. Test whether number of new clients affects sales generated using F test. Sandwich (Restaurant) Quarter-pound Single (Wendy's) Whataburger (Whataburger) Cheeseburger (In-n-Out) Big Mac (McDonald's) Quarter-pound Single (McDonald's) Whooper with cheese (Burger King) Jumbo Jack (Jack in the Box) Double Steakburger with cheese (Steak'nShake) Fat 20 39 27 29 26 47 35 38 Calories 430 750 480 540 510 760 690 632 Descriptive Statistics Fat Calories Mean Standard Error Median Mode Sample Standard Deviation Sample Variance Kurtosis Skewness Range Minimum Maximum Sum Count
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Thank you so much

Running head: Assignment 07

1

Assignment 07:
Name:
Institution affiliation:
Date:

Assignment 07

2

1. Generate a scatter plot between the number of new clients and sales using Excel.

Sales vs number of new cleints
70
60

Sales

50
40
30
20
10
0
0

10

20

30

40

50

Clients

2. Run a regression of the number of new clients on sales, and report the results using Excel.
SUMMARY OUTPUT
Regression Statistics
Multiple R
0.885801581
R Square
0.78464444
Adjusted R Square
0.763108884
Standard Error
5.804049746
Observations
12
ANOVA

Regres
sion
Residu
al
Total

Interce
pt
Clients
(X)

df

SS

MS

F

1

1227.
38
33.68
6...


Anonymous
Just the thing I needed, saved me a lot of time.

Studypool
4.7
Indeed
4.5
Sitejabber
4.4

Similar Content

Related Tags