1 calculate the mean and standard deviation of of sales, Ask an Expert

Economics

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.

View complete question

Microeconomics, Economics

Category:- Microeconomics
Reference No.:- M91295724
Price:- $20

Guranteed 24 Hours Delivery, In Price:- $20

Have any Question?Write your Review or question?

Related Questions in Microeconomics

Question a video rental store has estimated that the

Question: A video rental store has estimated that the inverse demand equation for video rentals by a typical customer is P = 6.50 - 0.5Q. The marginal cost of each rental is $2.50. If the video rental store engages in tw ...

Quesiton tax ratessuppose taxes are related to income as

Quesiton: (Tax Rates)Suppose taxes are related to income as follows: Income Taxes $1,000 $200 $2,000 $350 $3,000 $450 1. What percentage of income is paid in taxes at each level? 2. Is the tax rate progressive, proportio ...

Question suppose that there is an urgent need for new

Question: Suppose that there is an urgent need for new school buildings and teachers that emerged after hurricane Harvey in Houston, Texas. Answer the following questions about grants. a. Explain why a block grant, in co ...

Question discuss bowlbys attachment theory and your

Question: Discuss Bowlby's attachment theory and your understanding of what factors promote healthy attachments, long term implications of the various attachment styles and why all of this is so important. The response m ...

Question outline how neoclassical economists derive the law

Question: Outline how neoclassical economists derive the law of demand and then criticize neo- classical consumer/demand theory from a heterodox perspective in light of real world consumer behavior (include Veblen's and ...

Question you have just been hired by a company to evaluate

Question: You have just been hired by a company to evaluate the way the company treats its employees, suppliers, and customers. Create an analysis of the ethical theories the company would want to use to show the employe ...

Question suppose the united states increases the penalties

Question: Suppose the United States increases the penalties for illegal immigration to include long jail sentences for illegal workers. Analyze the effects of this increased penalty on the wages and employment levels of ...

Question supply and demand a process of coordinationit

Question: Supply and Demand, A Process of Coordination It seems like the economy was not working very well in NY and NJ after Sandy. On the other hand, it would be hard to imagine that any economy would be unfazed by a S ...

Question research your present or past companys view on

Question: Research your present or past company's view on corporate social responsibility. If you do not currently work for a company, pick a company that supports corporate social responsibility. Are there programs or i ...

Question assume that there exists an unlimited number of

Question: Assume that there exists an unlimited number of different approaches to developing a new drug, each costing $1. The probability that the drug will be discovered by at least one of the approaches is increasing i ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Microeconomics Expert