Prepare a report using regression analysis, Advanced Statistics

Paul Jordan has just been hired as a management analyst at Digital Cell Phone Inc. Digital Cell manufactures a broad line of phones for the consumer market. Paul's boss, John Smithers, chief operations officer, has asked Paul to stop by his office this morning. After a brief exchange of pleasantries over a cup of coffee, he says he has a special assignment for Paul: "We've always just made an education guess about how many phones we need to make each month. Usually w e just look at how many we sold last month and plan to produce about the same number. This sometimes works fine. But most months we either have too many phones in inventory or we are out of stock. Neither situation is good."

Handing Paul the table shown here, Smithers continues, "Here are our actual orders entered for the past 36 months. There are 144 phones per case. I was hoping that since you graduated recently from the University of Alaska, you might have studied some techniques that would help us plan better. It's been a while since I was in college- I think I forgot most of the details I learned then. I'd like you to analyze these data and give me an idea of what our business will look like over the next 6 to 12 months. Do you think you can handle this?"

"Of course," Paul replies, sounding more confident than he really is. "How much time do I have?"

"I need your report on the Monday before Thanksgiving-that would be November 20th. I plan to take it home with me and read it during the holiday. Since I'm sure you will not be around during the holiday, be sure that you explain things carefully so that I can understand your recommendation without having to ask you any more questions. Since you are new to the company, you should know that I like to see all the details and complete justification for recommendations from my staff."

With that Paul was dismissed. Arriving back at his office, he began his analysis.

Discussion Questions:

1.) Prepare Paul Jordan's report to John Smithers using regression analysis. Provide a summary of the cell phone industry outlook as part of Paul's response.

2.) Adding seasonality into your model, how does the analysis change?

Posted Date: 3/2/2013 3:01:36 AM | Location : United States







Related Discussions:- Prepare a report using regression analysis, Assignment Help, Ask Question on Prepare a report using regression analysis, Get Answer, Expert's Help, Prepare a report using regression analysis Discussions

Write discussion on Prepare a report using regression analysis
Your posts are moderated
Related Questions
literature review of latin square design.

A two-step distillation and mixing process is shown in the figure. The system operates at steady-state conditions and there are no chemical reactions. The known flow rates and comp

The function of a variable t which, when extended formally as a power series in t, yields factorial moments as the coefficients of the respective powers. If the P(t) is probability

Consolidated Standards for Reporting Trials (CONSORT) statement : The protocol for reporting the results of the clinical trials. The core contribution of the statement comprises of

Suppose the graph G is n-connected, regular of degree n, and has an even number of vertices. Prove that G has a one-factor. Petersen's 2-factor theorem (Theorem 5.40 in the note

Jelinski  Moranda model is t he model of software reliability which supposes that failures occur according to the Poisson process with a rate decreasing as more faults are diagnos

Morbidity is the term used in the epidemiological studies to describe sickness in the human populations. The WHO Expert Committee on the Health Statistics noted in its sixth repor

How is the rejection region defined and how is that related to the z-score and the p value? When do you reject or fail to reject the null hypothesis? Why do you think statisticians

sales per day for a product are as follows: x= 10, 11, 12, 13 (p)= 0.2, 0.4, 0.3, 0.1 obtain mean and variance of daily sale. if the profit is described by the following equation p

Lagrange Multiplier (LM) test The Null Hypothesis - H0: There is no heteroscedasticity i.e. β 1 = 0 The Alternative Hypothesis - H1:  There is heteroscedasticity i.e. β 1