Calculate the impact of increasing the sample size

Assignment Help Econometrics
Reference no: EM131927660

Assignment

Part 1
You manage Human Relations for your company. One of your sales managers has retired, leaving an opening. You are considering two

different employees for the position. Both are highly qualified so you have decided to evaluate their sales performance for the past year.
Use the Week 4 Data Set to create and calculate the following in Excel®:

1. Determine the range of values in which you would expect to find the average weekly sales for the entire sales force in your company 90% of the time.

o Calculate the impact of increasing the confidence level to 95%?

o Calculate the impact of increasing the sample size to 150, assuming the same mean and standard deviation, but allowing the confidence level to remain at 90%?

2. Based on the calculated confidence interval for weekly sales on the sample of 50 reps at a 90% confidence level:

o Calculate both Reps' average weekly performance and highlight if it is greater than the population mean.

3. You want to determine whether there is a statistically different average weekly sales between Sales Rep A and Sales Rep B.

o Create Null and Alternative Hypothesis statements that would allow you to determine whether their sales performance is statistically different or not.

o Use a significance level of .05 to conduct a t-test of independent samples to compare the average weekly sales of the two candidates.

o Calculate the p-value?

4. Considering that individual you did not promote:

o Determine whether this person's average weekly sales are greater than the average weekly sales for the 50 sales reps whose data you used to develop confidence intervals.

o Create Null and Alternative Hypothesis statements that would allow you to determine whether the new Sales Manager's weekly average sales are greater than the sample of Sales Reps.

o Use a significance level of .05 to conduct a t-test of independent samples to compare the average weekly sales of both.

o Calculate the p-value?

Part 2

Reference your Excel spreadsheet from Part 1.

Attachment:- Data-Sets.rar

Reference no: EM131927660

Questions Cloud

Create your accreditation plan address all of the functions : How will you fulfill the requirements for each function as required by the American Corrections Association? Be specific and explain in detail.
Where did you learn about ethics : Where did you learn about ethics? Why are ethical concerns important when studying entrepreneurship? How can ethics or the lack thereof impact an organization?
What recommendations would you give the company : Describe a company that you believe does not do well putting the 4Cs into practice, and provide two (2) examples of why you believe they struggle with it.
What functions does the office of the secretary : Describe and discuss how the U.S. Constitution as well as homeland security policies, laws, and strategies relate to the various disciplines.
Calculate the impact of increasing the sample size : Calculate the impact of increasing the sample size to 150, assuming the same mean and standard deviation, but allowing the confidence level to remain at 90%?
Compare pricing strategies for new products : Before engaging in the discussions each week, please read/view all of the readings and resources provided in the unit
Develop a page sentence outline for your paper : Develop a 2-3 page sentence outline for your paper, and complete an annotated bibliography with a minimum of six (6) peer-reviewed resources.
Compare different types of national health care systems : Differentiate between net present value and internal rate of return for capital investment. Compare and contrast different types of national health care system.
How much will leo receive after one year : a) How much will Leo receive after one year if he invests at the one-year rate?

Reviews

Write a Review

Econometrics Questions & Answers

  Develop a chart that would be of interest

Your company bid this contract with the promise to complete the job within 185 days. What is the probability of completing this project in that time frame? (Show your work.)

  1 john davis a recent ie graduate from tennessee

1. john davis a recent ie graduate from tennessee technological university bought an suv for 30000 with a down payment

  What are some arguments in favor of this proposal

In his book At the Hand of Man, Raymond Bonner argues that Africa should promote hunting, charging large fees for permits to kill animals (for example, $7,500 for a permit to shoot an elephant).

  How should firm vary its original output and price

For example, suppose an improved version of a product increases customer value added by $25 per unit. (In effect, the demand curve undergoes a parallel upward shift of $25.) a. If the redesign is expected to increase the item's marginal cost by $3..

  Will he allocate it to snowboarding or jazz

In the example given in Table 6.1, suppose Neal experiences a small increase in income. Will he allocate it to snowboarding or jazz?

  Compute the expected value and the standard deviation

Suppose an investment can yield three possible cash flows with their probabilities given in the parentheses: $600(p=0.5); $-100 (p=0.2) and $800 (p=0.3). a) Compute the expected value and the standard deviation of this investment. Is this investmen..

  What is the marginal product of the 3rd pound of rubber

Marginal revenue product is defined as the change in total revenue that results from the employment of an additional unit of a resource. A widget producer wishes to determine how the addition of pounds of rubber will affect its MRP

  What is the amount of profit that jonathan can maximize

Jonathan (a monopolist) maximizes profit by producing a quantity of 800 pillows where marginal cost is $2 and average cost is $4. Consumers are willing to pay as high as $10 per pillow when the quantity supplied is 800 pillows.

  What is the likely concentration 10 km from the plant site

The wind speed was 2 m/s and leak occurred on an overcast day. What is the likely concentration 10 km from the plant site?

  How does the availability of substitutes affect the price

How does the availability of substitutes affect the price elasticity of demand

  What people do rather than what they say they will do

Analyze how does the bank's finding relates to economists' traditional focus on what people do, rather than what they say they will do.

  Fancy gadgets inc has developed a new thing-a-may-jig at a

fancy gadgets inc. has developed a new thing-a-may-jig at a cost of 2000000. projected profits from the sale of

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