Explore BrainMass
Share

# Report for CEO

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

**SUMMARY OF PROBLEM:**

Section A: The company is thinking of launching a new product line and wishes to assess the likely response from regular customers.

1.What was the data mean or average satisfaction score?
2.What was the mode?
3.What was the median?
4.What was the standard deviation?
5.Which of the statistical results would mean the most to you if you did not know that the population's results were normally distributed? Why?
6.Would your answer be any different to question 5 if you knew that the population was normally distributed? Why?

Section B: Thinking back to your statistics courses, you noticed that the sample size was only 20.

1.Assuming the CEO would like to be able to believe the sample's average satisfaction score is no more than 0.25 of the real target market average satisfaction score, and would like to have a 95% confidence level in the validity of the result, what sample size should you have used in the market research?
2.What is the likely ramification of having too small a sample?

Section C: You wonder what the relationship is between customers' household incomes and their satisfaction with the new product line.

1.Fill out and turn in the Excel spreadsheet showing the data for which you will determine the correlation. What is the correlation coefficient?
2.Is there a strong or weak correlation? Is it positive or negative?
3.What conclusions can you reach about the relationship between household income and customer satisfaction?
4.As the vice president of marketing, what might you now do with this correlation information?

Section D: You want to use statistical analysis and hypothesis testing to determine if, given the sample information that you have, the target market will in fact have a mean of at least 4.0.

1.To properly answer this question, what would be the null hypothesis?
2.What would be the alternative hypothesis?
3.Assuming that you wish to have a 95% confidence interval in your conclusion, what is the value of the t-statistic and the test statistic?
4.What conclusion can you reach based on the test statistic?

Section E: The CEO also asked you to include in your report a "how to" set of instructions on using statistical process control in a manufacturing process.

1.In layman's terms, what is statistical process control (SPC)?
2.What information is needed to create an SPC chart?
3.Use the following information to create an actual SPC chart, and then plot the actual sample data points taken during the last 24 hours:
4.Based on what the chart now looks like, what observation can be made about the process from which the data was collected?

-------------------------------------------------

The CEO asked you to put together a report consisting of the following sections. Some of the report will be actual data analysis, some will be on sampling methods, and a section will be of value to the vice president of production.

Section A: The company is thinking of launching a new product line and wishes to assess the likely response from regular customers. A survey has been taken showing the following response to a question dealing with customers' satisfaction with the existing product line. On a scale of 1(very dissatisfied) to 5 (very satisfied), the responses from 300 customers were the following:

â?¢Score of 5: 120 or 40% of sample
â?¢Score of 4: 45 or 15% of sample
â?¢Score of 3: 45 or 15% of sample
â?¢Score of 2: 60 or 20% of sample
â?¢Score of 1: 30 or 10% of sample
â?¢Total sample: 300
Regardless of this sample, you feel that the actual satisfaction scores of the total target market are normally distributed. Answer the following:

1.What was the data mean or average satisfaction score?
2.What was the mode?
3.What was the median?
4.What was the standard deviation?
5.As a marketing person, which of the statistical results would mean the most to you if you did not know that the population's results were normally distributed? Why?
6.Would your answer be any different to question 5 if you knew that the population was normally distributed? Why?
Section B: Thinking back to your statistics courses, you noticed that the sample size was only 20, and you pulled out some of your old texts to check on what that meant in terms of your interpretation of the results.

1.Assuming the CEO would like to be able to believe the sample's average satisfaction score is no more than 0.25 of the real target market average satisfaction score, and would like to have a 95% confidence level in the validity of the result, what sample size should you have used in the market research? Assume the population is normally distributed.
2.What is the likely ramification of having too small a sample?
3.You also wonder if there is any correlation between household income and the satisfaction index on the new product, so you extract some more data from the market research, and add it to the table above.
Average household income:

â?¢Score of 5:8
â-¦\$38,000
â?¢Score of 4:3
â-¦\$50,000
â?¢Score of 3:3
â-¦\$48,000
â?¢Score of 2:4
â-¦\$80,000
â?¢Score of 1:2
â-¦\$85,000
â?¢Total sample: 20
Section C: You wonder what the relationship is between customers' household incomes and their satisfaction with the new product line.

1.Fill out and turn in the Excel spreadsheet showing the data for which you will determine the correlation. What is the correlation coefficient?
2.Is there a strong or weak correlation? Is it positive or negative?
3.What conclusions can you reach about the relationship between household income and customer satisfaction?
4.As the vice president of marketing, what might you now do with this correlation information?
Section D: You know from previous experience that the most successful new product launches have prelaunch sample satisfaction scores of 4.0. You want to use statistical analysis and hypothesis testing to determine if, given the sample information that you have, the target market will in fact have a mean of at least 4.0.

1.To properly answer this question, what would be the null hypothesis?
2.What would be the alternative hypothesis?
3.Assuming that you wish to have a 95% confidence interval in your conclusion, what is the value of the t-statistic and the test statistic?
4.What conclusion can you reach based on the test statistic?
Section E: The CEO also asked you to include in your report a "how to" set of instructions on using statistical process control in a manufacturing process, so you have to add the following to the final section of the report:

1.In laymanâ??s terms, what is statistical process control (SPC)?
2.What information is needed to create an SPC chart?
3.Use the following information to create an actual SPC chart, and then plot the actual sample data points taken during the last 24 hours:
1.Part dimension and tolerance should be 1.0 +/- 0.025.
2.The SPC chart should show UCL, LCL, USL, and LSL lines, plus the sample data from the last 24 hours
3.When the process capability study was done a week ago, and the process was deemed to be capable of producing parts to specification, the results of consecutive samples showed 4 parts at 1.0, 4 parts at 1.01, 2 parts at 0.99, 5 parts at 0.98, and 5 parts at 0.985.
4.Todayâ??s sample of 5 consecutive parts measured out at 1.032, 1.034, 1.0346, and 1.0345.
4.Based on what the chart now looks like, what observation can be made about the process from which the data was collected?

https://brainmass.com/statistics/quantative-analysis-of-data/report-for-ceo-423861

#### Solution Preview

I've attached explanations in a Word document and as a pdf. I've also attached an Excel files with some of the calculations that were used and an image (the control chart in the last section).

Let me know if you have any questions!!!

--------------------------

The CEO asked you to put together a report consisting of the following sections. Some of the report will be actual data analysis, some will be on sampling methods, and a section will be of value to the vice president of production. &#8232;&#8232;

Section A: The company is thinking of launching a new product line and wishes to assess the likely response from regular customers. A survey has been taken showing the following response to a question dealing with customers' satisfaction with the existing product line. On a scale of 1(very dissatisfied) to 5 (very satisfied), the responses from 300 customers were the following: &#8232;&#8232;

â?¢Score of 5: 120 or 40% of sample &#8232;
â?¢Score of 4: 45 or 15% of sample
â?¢Score of 3: 45 or 15% of sample &#8232;
â?¢Score of 2: 60 or 20% of sample
â?¢Score of 1: 30 or 10% of sample &#8232;
â?¢Total sample: 300 &#8232;

Regardless of this sample, you feel that the actual satisfaction scores of the total target market are normally distributed. Answer the following: &#8232;&#8232;

1.What was the data mean or average satisfaction score? &#8232;

We are given a frequency distribution. To calculate the mean of a distribution like this, multiply each score by the number of customers, add everything up, and divided by the total sample size:

mean = 5(120) + 4(45) + 3(45) + 2(60) + 1(30)
300

= 1065/300 = 3.55

2.What was the mode? &#8232;

The mode is the score that shows up most often in the sample. Here, the mode is 5 because more people had a satisfaction score of 5 than any other score.

3.What was the median? &#8232;

The median is the middle number if the scores are listed from smallest to largest. There are 300 data points, so the middle number is going to be the average of the 150th and 151st score (300 is even so there is not a single "middle" number). The 150th and 151st scores are both 4. Therefore, the median is 4.

4.What was the standard deviation? &#8232;

The standard deviation is a measure of how far the data spreads around the mean. It involves some calculations to determine it by hand, and we're going to follow the method here: http://www.ltcconline.net/greenl/courses/201/descstat/meanSDGrouped.htm

Here are the calculations:

Score (x) Frequency (f) x * f x^2 * f
5 120 600 3000
4 45 180 720
3 45 135 405
2 60 120 240
1 30 30 30

TOTAL 300 1065 4395

SSx = 4395 - (1065)^2/300 = 614.25

std. dev = sqrt(614.25/299) = 1.433299629

The standard deviation is 1.433.

(Note: Some people divide by n - 1 when calculating the standard deviation, others divide by n. If we divide by n - 1, we get 1.433 as the standard deviation. If we divide by n, we get 1.431 as the standard deviation. See http://www.graphpad.com/faq/viewfaq.cfm?faq=1382 for a discussion on when you would use the two different methods of ...

\$2.19

## Multiple Regression Analysis, Time Series Analysis

See attached data file.

Background:

One day, after reporting the performance of the company to the shareholders, the CEO of A. Fictitious & Co. decided that he would like to quantify the impact of the company's expenditures has on how much sales it generates. In other words, he would like to know if the company increases the amount spent on marketing by one dollar, how large of an increase (or decrease) in sales would be expected? The major categories of expenditures and how much was spent in each are known for the company, as is the total sales generated per quarter for the last five years. He has the data file with the relevant data sent to you, and asks you to do the multiple-regression analysis to find out the answer to his questions. Oh, and he also asks you to do a time-series analysis on the total sales per quarter and forecast the amount of sales expected in the future.

Part I. Multiple Regression:

1. Look over the expenditure categories that the CEO gave you. Check to see if there interaction between the category Capital Equipment and Materials, and the category Salary and Benefits. Namely, do a multiple regression model with quarterly sales as the y-variable and the four expenditure categories given in the Data set as the x-variables. Do a second multiple regression model with four expenditure categories plus an interaction term between the category Capital Equipment and Materials, and the category Salary and Benefits. After comparing the two models, which is the better model? Can you conclude whether the two categories are independent of each other?

2. Based on your analysis in Question 1, write down the best-fit multiple regression equation for this problem with quarterly sales as the y-variable and the expenditure categories as the x-variables; do not forget the interaction term if there is one. Define each variable in the equation.

3. Answer the CEO's question. Namely, for each the four categories of expenditure (marketing, R&D, equipment and supplies, and salaries and benefits), if the CEO increases spending in one category by one million dollars (holding the others fixed), how much increase in sales should he expect? If you found an interaction term, explain its effects as well.

4. Being a very cautious person, you decide to also give the CEO the confidence intervals for the rates of increase your calculated in Question 3. Calculate the 95% confidence intervals for the slopes you calculated in Question 2, including the interaction term if you found one.

5. Being even more cautious - you are reporting the results to the CEO, after all - you decide to do a residual error analysis by applying the F-Test on the entire regression model. Do so, and interpret the results.

Part II. Time-series Analysis

The CEO noticed that he has five years of quarterly sales data in hand, and they form a time series. He decided to also ask you to perform time-series analysis on it, and use it to forecast what future sales are expected to be at the end of 1Q 2009.

6. Plot the quarterly sales as a function of time in your Excel data spreadsheet. From the shape of these graphs, and any analysis that you think is needed, determine what type of trend model is best suitable for this data. Write down the equation for the trend model, and define and explain each of the variables as it applies to this problem.

7. Do a regression analysis on the data for the trend model you decided on in Question 6, and determine the parameters for the model.

8. Answer the CEO's question. Tell him how much sales are expected to be at the end of 1Q 2009. Be careful, and also include the 95% confidence interval for this number.

Part III. Conclusions

9. Write a report to the CEO of your findings. Which expenditure has the largest impact on sales, and which one has the least impact on sales? How fast do you expect sales to increase in time?

10. When tasked to do this analysis, the CEO made a number of assumptions about the data, and what can be extrapolated from it. List down the assumptions he made, and criticize each assumption. Criticize also the conclusions that you drew from your analysis for your report to the CEO. As a starting point, remember that the data covered a period of five years.

View Full Posting Details