Calculate the mean and standard deviation of sales people

Assignment Help Microeconomics
Reference no: EM13737379

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.

Reference no: EM13737379

Questions Cloud

Question regarding the labor relations : Analyze the collective bargaining process, negotiating labor agreements and resolving impasses, and determine how these activities will "evolve" in the foreseeable future.
Outcome in a challenging situation : Describe a scenario where appreciative intelligence would yield a more positive outcome in a challenging situation.
Promote change in clients : What are some appropriate recommendations to promote change in clients who have a chemical dependency problem? How might you generalize this to other populations?
How marketing costs are lower : How marketing costs are lower and show new market opportunities were created and How it helped income all year round, benefited the local market, and reduced expenses
Calculate the mean and standard deviation of sales people : Calculate the mean and standard deviation of sales people (x) and sales (y). Find sample size n - Calculate the correlation coefficient with all three methods.
Employee of the organization : As a human resources manager, you realize that performance management must be considered even before a person becomes an employee of the organization. One of your goals is to reduce employee turnover through the revision of the personnel assessmen..
American payroll association : The American Payroll Association, APA, has developed a "Code of Ethics" for their membership. Review the Code of Ethics and the website for the APA
A manufacturer is considering changing its process to reduce : A manufacturer is considering changing its process to reduce pollution emissions. The current process has an annual operating cost of $850,000 and an annual waste disposal cost of $150,000. The new process will have an annual operating cost of $700,0..
What level in the consumer-value hierarchy : Marketers must see themselves as benefit providers. For example, when a shopper purchases new shoes, he or she expects the shoes to cover his or her feet and allow him or her to walk unobstructed. This is an example of what level in the consumer-v..

Reviews

Write a Review

Microeconomics Questions & Answers

  The free rider problem

Question: Explain why the free rider problem makes it difficult for perfectly competitive markets to provide the Pareto efficient level of a public good.

  Failure of the super committee is good thing for economy

Some commentators have argued that the failure of the “Super committee” is good thing for the economy?  Do you agree?

  Case study analysis about optimum resource allocation

Case study analysis about optimum resource allocation: -  Why might you suspect (even without evidence) that the economy might not be able to produce all the schools and clinics the Ministers want? What constraints are there on an economy's productio..

  Fixed cost and vairiable cost

Questions:  :   Which of the following are likely to be fixed costs and which variable costs for a chocolate factory over the course of a month?  Explain your choice.

  Problem - total cost, average cost, marginal cost

Problem - Total Cost, Average Cost, Marginal Cost: -  Complete the following table of costs for a firm.  (Note: enter the figures in the  MC   column  between  outputs of  0 and 1, 1 and 2, 2 and 3, etc.)

  Oligopoly and demand curve problem

Problem based on Oligopoly and demand curve,  Draw and explain the demand curve facing each firm, and given this demand curve, does this mean that firms in the jeans industry do or do not compete against one another?

  Impact of external costs on resource allocation

Explain the impact of external costs and external benefits on resource allocation;  Why are public goods not produced in sufficient quantities by private markets?  Which of the following are examples of public goods (or services)? Delete the incorrec..

  Shifts in demand and movements along the demand curve

Describe the differences between shifts in demand and movements along the demand curve. What are the main factors which can shift the demand curve? Explain why they cause the demand curve to shift. Use examples and draw graphs to support your discuss..

  Article review question

Article Review Question: Read the following excerpts from the article "Fruit, veg costs surge' by Todd, Dagwell, published in the Herald on January 25th 2011 and answer questions below:

  Long-term growth, international trade & globalization

Long-term Growth, International Trade & Globalization:- This question deals with concepts such as long-term growth, international trade and globalization. Questions related to trade deficit, trade surplus, gains from trade, an international trade sce..

  European monetary union (emu) in crisis

"Does the economic bailout of Spain and Greece spell the beginning of the end for the European Monetary Union (EMU)?"

  Development game “settlers of catan”

Read the rules of the game, the overview and the almanac for the Development Game "Settlers of Catan"

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd