Critical tool for a managers decision-making

Assignment Help Basic Statistics
Reference no: EM13251117

1.The University of Ohio is concerned that out-of-state students may be receiving lower grades than Ohio students. Two independent random samples have been selected: 165 observations from population 1 (out-of-state students) and 177 from population 2 (Ohio students). The sample means obtained are X1(bar)=86 and X2(bar)=87. It is known from previous studies that the population variances are 8.1 and 7.3 respectively. Using a level of significance of .01, is there evidence that the out of state students may be receiving lower grades? Fully explain your answer.

Simple Regression

2.A CEO of a large pharmaceutical company would like to determine if the company should be placing more money in the budget next year for television advertising of a new drug for controlling diabetes. He wonders whether there is a strong relationship between the amount of money spent on television advertising for this new drug called DIB and the number of orders received. The manufacturing process of this drug is very difficult and requires stability, so the CEO would prefer to generate a stable number of orders. The cost of advertising is always an important consideration in the phase I roll-out of a new drug. Data that have been collected over the past 20 months indicate the amount of money spent of television advertising and the number of orders received.

The use of linear regression is a critical tool for a manager's decision-making ability. Please carefully read the example below and try to answer the questions in terms of the problem context. The results are as follows:

Month

Advertising Cost

Number of Orders

1

$74,430.00

2,856,000

2

62,620

1,800,000

3

67,580

1,299,000

4

53,680

1,510,000

5

69,180

1,367,000

6

73,140

2,611,000

7

85,370

3,788,000

8

76,880

2,935,000

9

66,990

1,955,000

10

77,230

3,634,000

11

61,380

1,598,000

12

62,750

1,867,000

13

63,270

1,899,000

14

86,190

3,245,000

15

60,030

1,934,000

16

79,210

2,761,000

17

67,770

1,625,000

18

84,530

3,778,000

19

79,760

2,979,000

20

84,640

3,814,000

A. Set up a scatter diagram and calculate the associated correlation coefficient. Discuss how strong you think the relationship is between the amount of money spent on television advertising and the number of orders received. Please use the Correlation procedures within Excel under Tools > Data Analysis.The scatterplot can more easily be generated using the "Chart" procedure.

NOTE: If you do not have the Data Analysis option under Tools you must install it. You need to go to Tools, select Add-ins and then choose the two data toolpak options. It should take about a minute.

B. Assuming there is a statistically significant relationship, use the least squares method to find the regression equation topredict the advertising costs based on the number of orders received. Please use the regression procedure within Excel under Tools > Data Analysis to construct this equation.

C. Interpret the meaning of the slope, b1, in the regression equation.

D. Predict the monthly advertising cost when the number of orders is 2,300,000. (Hint: Be very careful with assigning the dependent variable for this problem.)

E. Compute the coefficient of determination, r2, and interpret its meaning.

F. Compute the standard error of estimate, and interpret its meaning.

G. Do you think that the company should use these results from the regression to base any corporate decisions on? Fully explain your answer.

Hypothesis Testingon Multiple Populations

3. Dr. Michaella Evans, a statistics professor at a University , drives from her home to the school every weekday. She has three options to drive there: She can take the Beltway, or she can take a main highway with some traffic lights, or she can take a back road which has no traffic lights but is a longer distance. Being as data-oriented as she is, she is interested to know if there is a difference in the time it takes to drive each route.

As an experiment, she randomly selected the route on 21 different days and wrote down the time it took her for the round trip, getting to work in the morning and back home in the evening.At the .01 significance level, can she conclude that there is a difference between the driving times using the different routes?

Time (in minutes) it took to get to work and back using:

Beltway

Main highway

Back road

88

79

86

94

86

78

91

75

79

88

83

96

98

74

97

84

72

73

90


68

77



Reminder: Please use the five-steps for hypothesis testing as outlined in your Lind textbook. Yes, that means I want you to label and discuss each step (Step 1, Step 2, etc.).

Reference no: EM13251117

Questions Cloud

Explain why norton equivalent circuit approximates sources : A 100 V power supply has a series limmitin restor of 100 k ohms connected to its output. draw the norton equivalent cirtuit for the power supply. explain why the norton equivalent circuit you drew approximates an ideal current source
Find the speed of the particle if it is a proton : A charged particle travels undeflected through perpendicular electric and magnetic fields whose magnitudes are 5000N/C, Find the speed of the particle if it is a proton
Compute the molality of ions in a solution : Calculate the molality of ions in a solution made by mixing 5.14 g of CaCl2, MW=110.98, in 79.38 mL of water at 37.0°C. The density of water at this temperature is 0.9933 g/cm3. The answer is 1.76m but I don't know how to get there.
Find the force on the wire : A 3.0m length of straight wire carries a current of 16A in a uniform magnetic field of 50mT whose direction is at an angle of 36? , Find the force on the wire.
Critical tool for a managers decision-making : Use of linear regression is a critical tool for a managers decision-making ability - Using a level of significance of .01, is there evidence that the out of state students may be receiving lower grades? Fully explain your answer.
Describe how that organization maintains or attempts : Within your organization, or one with which you may be familiar, describe how that organization maintains or attempts to maintain competitive advantage. What do they do well? What improvements could they make? Support your answer.
Explain the type of nuclear reaction : The type of nuclear reaction shown below is which can be recognized by the fact that it has 2 reactant and 2 products
How much power would that be on the average : A common energy consumption for a family is about 1000 kW hr / month. How much power would that be on the average. (Hint: Notice that hour and month are both units of time so kW hr per month is really a power unit.
Explain the highest-energy subshell at the top : Show the orbital-filling diagram for S (sulfur). Stack the subshells in order of energy, with the lowest-energy subshell at the bottom and the highest-energy subshell at the top.

Reviews

Write a Review

Basic Statistics Questions & Answers

  Evaluate total sum of squares

Reading highway signs is not always easy, especially if your vision is imperfect. Vision in general tends to deteriorate with age. Two researchers conducted a study to determine if the distance at which a standard highway sign could be recognized ..

  Probability of answering question correctly

Find the probability that he will answer at least 3 questions correctly.

  Statement made for a given paired sample

Test of claim for the statement made for a given paired sample:

  Probability that selected student spends eighty percent time

Find the probability that a randomly selected student spends between eighty and ninety percent of the time on the test. Find the expected value of X. E(X)

  Observing a sample proportion of voters

Calculated the probability of observing a sample proportion of voters 0.55 or higher supporting the incumbent governor.

  Estimating a population proportion

The manager of a department store wants to determine what proportion of people who enter the store use the store's credit cards for their purchases.

  Creating confidence interval for proportion of adults

Election poll reported that applicant had n approval rating 31% with margin of error E of 4%. Create a confidence interval for proportion of adults who approved of applicant.

  Mean and standard deviation of the sample mean

For sample of size 100, what is the mean and standard deviation of the sample mean.

  Chi-square goodness of fit test

The chi-square goodness of fit test can be used when we:

  Future decisions verus work options

a) Do a test to see if workers attitudes on this matter have changed using a 90% alpha. b) Explain to management what your findings are and what this suggests about future decisions vs work options.

  Median sales price of new homes

The U.S.Census Bureau announced that the median sales price of new homes sold i April 2009 was $221,660, and the mean sales price waas $274,300. Assume that the standard deviation of the prices is $90,000.

  Evaluate a simple aggregate price index

Evaluate a simple aggregate price index for 2004. Use 2000 as the base period - Estimating the simple aggregate price index.

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