Reference no: EM13727081
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.
|
Explain the importance of understanding cultural and ethnic
: Your assignment is to write a brief two- to three-page essay paper, double-spaced, on the importance of understanding cultural, ethnic, and gender differences by managers and professionals in a business setting.
|
|
Compare the pre-unification theban style
: Compare the pre-unification Theban style to that of the block statue style that began in the early Twelfth Dynasty. Where do you see we see the most notable difference
|
|
Developing the organization''s financial plan
: Your company's chief financial officer (CFO) begins the preliminary work of developing the organization's financial plan for the upcoming year. Recently, there have been media reports that your state will be cutting health care costs by reducing b..
|
|
Describe market entry strategies
: Market Entry Strategies: Choose two articles from the Argosy Online Library, one that addresses Market Choice Strategies and one that addresses Market Expansion Strategies
|
|
Calculate the correlation coefficient with all methods
: Calculate the mean and standard deviation of # of sales people (x) and sales (y). Find sample size n - Calculate the correlation coefficient with all three methods (covariance method, z-score method, and correlation tool in Excel).
|
|
How did the gold rush transform the young men
: How did the Gold Rush transform the young men who came to California to seek their fortune transform them from farmers, or businessmen, factory workers, or "second sons" into "49'ers"? How and why did they change?
|
|
Assignment on gathering performance information
: Assignment on Gathering Performance Information. The process of gathering performance information can result in a wide variety of reactions in both employees and managers. Think back to a performance appraisal experience you have had and respond t..
|
|
Negotiate purchase contract for manufacturing facility
: Negotiate the purchase contract for the manufacturing facility - The type of entity chosen and why, your entity's name, your entity's business purpose, a hierarchy of ownership, management and control appropriate to the selected type of organizatio..
|
|
Critical success factors for retail e business startups
: Question 1: Most businesses should engage in e-commerce on the Internet. Do you agree or disagree with this statement? Explain your position. Question 2: What are the critical success factors for retail e-Business startups?
|