Improve model by eliminating certain independent variables

Assignment Help Advanced Statistics
Reference no: EM13763022

Case: The Construction Department at Croqpain

Assignment:

Using the data for this case, provided in the spreadsheet file entitled CROQ-PAIN.xls, do the following:

(a) Examine the operating earnings regression model output obtained from the 60 stores, as shown in Table 6.27. Try to improve the model by eliminating certain independent variables or by making any other changes that you think make good sense. You should strive for a model that is simple (i.e., has few independent variables), that does not violate any of the basic assumptions of multiple regression (e.g., multicollinearity, heteroscedasticity), but nevertheless has good predictive power.

(b) Michel thinks that a good way to validate the model obtained with data from the 60 stores is to see how a similar model, obtained from the 50 stores opened before 1994, would have performed in predicting the performance of the last ten stores opened. Step back one year, prior to the opening of the last ten restaurants. Amend the model you have developed using only the data from the first fifty stores. Using Croq'Pain's performance ratio target of 26%, which of the ten stores would you have opened in 1994?

(c) Croq'Pain's strategic planning group has developed a list of ten potential store locations for 1996 shown in Table 6.28. Which of these locations would you select, i.e., which locations meet or exceed the performance ratio? Use the most complete model (60 restaurants) for your analysis.

(d) Prepare a memorandum containing your recommendations as to whether, and how, regression models can be used in the process of location selection. Defend your recommendations with a discussion of the relative strengths and weaknesses of regression models in this setting.

Attachment:- croqpain.rar

Reference no: EM13763022

Questions Cloud

Summarize the relationship between classes and unions : Write a paper in which you summarize the relationship between structures, classes, and unions in object-oriented programming.
What are strategies for reducing behavior problems in class : What are three strategies for reducing and preventing behavior problems in the preschool classroom?
Write a program that uses a random number generator : Write a program that uses a random number generator to generate a two digit positive integer
Significant event relate to the changes on health care : Do you personally agree with the event's significance, based on your beliefs and values?
Improve model by eliminating certain independent variables : Examine the operating earnings regression model output obtained from the 60 stores, as shown in Table 6.27. Try to improve the model by eliminating certain independent variables or by making any other changes that you think make good sense
Compute volcans market value of equity : Compute Volcans's market value of equity before it announces the purchase. Suppose Volcan decides to its internally generated funds to finance the purchase.
Write a program that will calculate number of square feet : write a program that will calculate the number of square feet (living space) in a 4-room house. Your analysis should be clearly written and demonstrate your thought process and steps used to analyze the problem.
The organization of health care : Discuss the social, ethical, and economic impact of your product, service, or application to the organization.
The bond''s price in dollars and percentage terms : A $1,000 face value corporate bond with a 6.75 percent coupon (paid semiannually) has 10 years left to maturity. It has had a credit rating of BB and a yield to maturity of 8.2 percent. The firm recently became more financially stable and the rating ..

Reviews

Write a Review

 

Advanced Statistics Questions & Answers

  Application of statistical process controls

For Linear Programming, you are to make up (or collect actual data) so as to be able to apply a complete linear programming optimization. Make sure to show the data to be used, show the linear program you create, and the solutio..

  Worker satisfaction-compensation strategy

How does one's ability, motivation and opportunities distinguish themselves as it relates to worker satisfaction? Explain the value of a strategic compensation strategy?

  Use of probability for business decisions

In your work environment, identify a probability (either stated or assumed) that is a premise for making decisions and directing action. Potential candidates are customer or competitor behavior, technology or regulatory change, and "forces of natu..

  Two twin brothers hank and crank are kicking a ball around

two twin brothers hank and crank are kicking a ball around in a park. tim challenges james to a contest on who can kick

  Accounting-inventory management

The Acme Grocery store started a Coupons Instantly program. It requires a debit card with a minimum of $300, so the customer can buy as many coupons as they want.

  Effect of vitamin d adjunct therapy

Write a typical protocol about the effect of Vitamin D Adjunct Therapy on the Progression of Latent Tuberculosis to Active Disease

  Probability concepts of business

As a health care manager, what are some benefits of applying probability concepts to solve business-related problems? Would business decisions suffer without probability concepts? Explain.

  Cost of equity for dell

Calculate the industry average beta for Dell, and then using the industry average beta compute the cost of equity for Dell. Does it matter if you use the beta for Dell or the beta for the industry in this case?

  Cost relevant for decision-making

What makes a cost relevant for decision-making? Why are fixed costs not relevant for most short-term decisions?

  Information regarding activity cost pools

You have given this information for ABC Corporation. What is the Activity Rate for the three Activity costs Pools?

  Cannondale gross profit and operating income

The following information was reported on the income statement of Cannondale in one of its early years of operation. Sales revenues, $450,000; Cost of goods sold, $200,000; Selling, general, and administrative, $150,000; Interest expense, $30,000.

  Pujols industries-bond issue entries

On February 28, 2006, Pujols Industries issued 10% bonds, dated January 1, with a face amount of $48 million. The bonds were priced at $42 million (plus accrued interest) to yield is 12%.

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