Question

Offered Price $20.99

MGMT 3100 mean and standard deviation of # of sales people

Question # 00531186
Subject: Biology
Due on: 05/21/2017
Posted On: 05/21/2017 08:10 AM

Rating:
4.1/5
Expert tutors with experiences and qualities
Posted By
Best Tutors for school students, college students
Questions:
17159
Tutorials:
17122
Feedback Score:

Purchase it
Report this Question as Inappropriate
Question

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.

Tutorials for this Question
Available for
$20.99

MGMT 3100 mean and standard deviation of # of sales people

Tutorial # 00528253
Posted On: 05/21/2017 08:11 AM
Posted By:
Best Tutors for school students, college students Prof.Charlie
Expert tutors with experiences and qualities
Questions:
17159
Tutorials:
17122
Feedback Score:
Report this Tutorial as Inappropriate
Tutorial Preview …and xxxxxxxx…
Attachments
soln.zip (652.26 KB)
Purchase this Tutorial @ $20.99 *
* - Additional Paypal / Transaction Handling Fee (3.9% of Tutorial price + $0.30) applicable
List of Main Subjects
Accounting
Anthropology
Architecture
Art
Asian Studies
Astronomy
Biology
Business
Chemistry
Communications
Computer Science
Economics
Education
Engineering
English
Finance
Foreign Languages
Gender Studies
General Questions
Geography
Geology
Health Care
History
Kindergarten
Law
Linguistics
Literary Studies
Marketing
Mathematics
Music
Nursing
Performing Arts
Philosophy
Physics
Political Science
Psychology
Religious Studies
Sociology
Statistics
Urban Planning and Policy
View all subjects...
Loading...