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.).

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.

Write a Review

Determine the daily supply in a more cost effective way

Whether regression can be used to estimate the Demand from other data in the file. So that Howies can determine the daily supply in a more cost effective way.

Build a portfolio optimization system

For good results, you probably need to work with 20 or more securities.  Try to include in your model realistic-type sector, industry, and upper bound constraints, but don't make them too tight.

Formula for linear function

Find a formula for the linear function described. The function, y=f(x), where f(c)=k, f(c+h)=3k and the graph of f(x) goes through the origin.

Mean perceived age estimation for all viewers

Let μ be the mean perceived age estimate for all viewers of the ad, and suppose we consider the industry requirement to be met if μ is at least 25. Set up the null and alternative hypotheses needed to attempt to show that the industry requirement ..

Determine probability that person would score more on test

The iq test score are normally distributed with a mean of 100 and a standard deviation of 15. Determine the probability that the person would score 130 or more on the test?

Power of a hypothesis test

Explain how the power of a hypothesis test is influenced by each of the following. Assume that all other factors are held constant.

Normal probability distribution and the standard deviation

For the most recent year available the mean annual cost to attend a private university in the US was \$26,889. Assume the distribution of annual costs follows a normal probability distribution and the standard deviation is \$4,500. 95% of all studen..

Validate the probability distribution

Determine the distributions given below represent a probability distribution. Justify your answer.

Wilcoxon rank-sum test

Suppose there are two samples of size 6 and 7, with a rank sum of 58 in the sample of size 6. Using the Wilcoxon rank-sum test, evaluate the significance of the results, assuming there are no ties.

Number of older siblings in the sample observations

An analyst wishes to include number of older siblings in family as a predictor variable in a regression analysis of factors affecting maturation in eighth graders. The number of older siblings in the sample observations ranges from 0 to 4.

Approximation of the actual results

Does the normal distribution yield a good approximation of the actual results?

Average waiting time til a electric utility customer

Nationwide, the average waiting time until a electric utility customer service representative answers a call is 210 seconds. The Gigantic Kilowatt Energy Company randomly sampled 30 calls and found that, on average, they were answered in 183 secon..