Prepare a report using regression analysis, Advanced Statistics

Assignment Help:

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?


Related Discussions:- Prepare a report using regression analysis

Multivariate data, Multivariate data is the data for which each observatio...

Multivariate data is the data for which each observation consists of the values for more than one random variable. For instance, measurements on the blood pressure, temperature an

Dendro gram, A term commonly encountered in the application of the agglomer...

A term commonly encountered in the application of the agglomerative hierarchical clustering techniques, where it refers to the 'tree-like' diagram illustrating the series of steps

Hirap, #q A paper mill products two grade of paper viz., X & Y. Because of ...

#q A paper mill products two grade of paper viz., X & Y. Because of raw material restriction, it cannot produce more than 400 tons of grade X paper & 300 tons of grade Y paper in a

Define probability judgements, Probability judgements : Human beings often ...

Probability judgements : Human beings often require assessing the probability which some event will occur and accuracy of these probability judgements often determines success of o

What is harris and stevens forecasting, Harris and Stevens forecasting is ...

Harris and Stevens forecasting is the method of making short term forecasts in the time series which is subject to abrupt changes in pattern and the transient effects. Instances o

Game theory, This is the branch of mathematics which deals with the theory ...

This is the branch of mathematics which deals with the theory of contests between two or more players under the specified sets of rules. The subject supposes a statistical aspect w

Cycle plot, The graphical method for studying the behavior of the seasonal ...

The graphical method for studying the behavior of the seasonal time series. In such a plot, the January values of seasonal component are graphed for the upcoming years, then the

Empirical bayes method, The procedure in which the prior distribution is re...

The procedure in which the prior distribution is required in the application of Bayesian inference, it is determined from empirical evidence, namely same data for which the posteri

Linear regression, regression line drawn as Y=C+1075x, when x was 2, and y ...

regression line drawn as Y=C+1075x, when x was 2, and y was 239, given that y intercept was 11. calculate the residual

Write Your Message!

Captcha
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