Posted: November 30th, 2022

Consider the following data from a small bookstore

Consider the following data from a small bookstore.
Number of sales people working—————–Sales (in $1000)
2————————————————————–10
3————————————————————–11
7————————————————————–13
9————————————————————–14
10————————————————————-18
10————————————————————-20
12————————————————————-20
15————————————————————-22
16————————————————————-22
20————————————————————-26
x = 10.4—————————————————–y = 17.6
SD(x) = 5.64———————————————–SD(y) = 5.34
1. Calculate the mean and standard deviation of # of sales people (x) and sales (y). Find sample size n.
2. Calculate the correlation coefficient with all three methods (covariance method, z-score method, and correlation tool in Excel).
3. Find b0 and b1 for the linear regression model with all three methods (two different formulas and Solver). Interpret the meaning of b1 of this linear regression model.
4. Calculate Se and SST.
5. Calculate R square with both methods (correlation coefficient method and the formula r square = 1 – SSE/SST). Interpret the meaning of R square of this linear regression model.
6. Use Regression tool in Excel to find b0, b1, SSE, SST, r, R square, and Se.
7. Estimate the sales if the number of sales people working is 8, 13, and 19, respectively.

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper

Expert paper writers are just a few clicks away

Place an order in 3 easy steps. Takes less than 5 mins.

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
$0.00
error: Content is protected !!
Open chat
1
Order through WhatsApp!
professionalsessays.com
Hello!
You Can Now Place your Order through WhatsApp
 

 

Order your essay today and save 15% with the discount code 2023DISCOUNT