# Estimate the sales if the number of sales people working is 8, 13, and 19, respectively.

17 / 01 / 2019 Research Papers

This paper circulates around the core theme of Estimate the sales if the number of sales people working is 8, 13, and 19, respectively. together with its essential aspects. It has been reviewed and purchased by the majority of students thus, this paper is rated 4.8 out of 5 points by the students. In addition to this, the price of this paper commences from £ 99. To get this paper written from the scratch, order this assignment now. 100% confidential, 100% plagiarism-free.

All the calculations 1-7 must be done with Excel. Consider the following data from a small… 1 answer below » All the calculations 1-7 must be done with Excel. 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). View complete question » All the calculations 1-7 must be done with Excel. 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. Additional Requirements Level of Detail: Show all work View less » Aug 01 2015 03:45 PM

### 100% Plagiarism Free & Custom Written

International House, 12 Constance Street, London, United Kingdom,
E16 2DQ

Company # 11483120

## STILL NOT CONVINCED?

We've produced some samples of what you can expect from our Academic Writing Service - these are created by our writers to show you the kind of high-quality work you'll receive. Take a look for yourself!

View Our Samples

## Benefits You Get

• Free Turnitin Report
• Unlimited Revisions
• Installment Plan
• Plagiarism Free Guarantee
• 100% Confidentiality
• 100% Satisfaction Guarantee
• 100% Money-Back Guarantee
• On-Time Delivery Guarantee +44 7340 9595 39
+44 20 3239 6980
care@hireresearcher.co.uk
AKOSZTEC “International House, 12 Constance Street, London, United Kingdom, E16 2DQ”

Hire Researcher
Rated 4.7/5 based on 8956 Reviews

## Supporting Pages

FLAT 25% OFF ON EVERY ORDER. Use "FLAT25" as your promo code during checkout