CourseLover

(12)

$10/per page/Negotiable

About CourseLover

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Algebra,Applied Sciences See all
Algebra,Applied Sciences,Architecture and Design,Art & Design,Biology,Business & Finance,Calculus,Chemistry,Engineering,Health & Medical,HR Management,Law,Marketing,Math,Physics,Psychology,Programming,Science Hide all
Teaching Since: May 2017
Last Sign in: 286 Weeks Ago, 3 Days Ago
Questions Answered: 27237
Tutorials Posted: 27372

Education

  • MCS,MBA(IT), Pursuing PHD
    Devry University
    Sep-2004 - Aug-2010

Experience

  • Assistant Financial Analyst
    NatSteel Holdings Pte Ltd
    Aug-2007 - Jul-2017

Category > Accounting Posted 17 Dec 2017 My Price 10.00

mean and standard deviation of # of sales people

Use the data from Exercise 1 of Section 6.1 in the supplementary materials (page 175) and answer the following questions in Excel. All the calculation must be done with Excel and please submit your Excel file here.

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.

 

I need all the answers in Excel, using excel tools. Also the interpretation of number 3 and 5.

In number 6 use regression tool in Excel. Show formulas.

Attachments:

Answers

CourseLover
(12)
Status NEW Posted 17 Dec 2017 11:12 AM My Price 10.00

-----------  ----------- H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------usi-----------ng -----------our----------- we-----------bsi-----------te -----------and----------- ac-----------qui-----------sit-----------ion----------- of----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------ns.----------- Pl-----------eas-----------e p-----------ing----------- me----------- on----------- ch-----------at -----------I a-----------m o-----------nli-----------ne -----------or -----------inb-----------ox -----------me -----------a m-----------ess-----------age-----------

Not Rated(0)