Question

In: Statistics and Probability

Nordique Products, Inc. is trying to decide which of two available strategies it will implement company-wide...

Nordique Products, Inc. is trying to decide which of two available strategies it will implement company-wide in the future – Strategy A or Strategy B.

To identify the best strategy, managers selected two samples of store locations (20 locations in each sample) and implemented one strategy in each sample.

After several months, the firm has compiled data from the different locations within each sample, and has run regression analyses using this data. A variety of independent / explanatory factors are included in the regression models.

The main dependent variable of interest is store profit. (You can assume that lag between the implementation of the strategy and financial results is minimal.)

Relevant information from the regression analysis for stores implementing Strategy A is as follows:

Count = 20

R-squared = 0.692

Adjusted R-squared = 0.651

Coefficient    Std Error t-value p-value   
Intercept 101,452 9,546 8.24 0.01
Strategy implementation score    9,659 946 4.10 0.01
Experience score 4,500 321 3.96 0.01
Market size 0.453 0.042 0.97 0.21
Customer satisfaction 25,409 3,422 2.24 0.04

Relevant information from the regression analysis for stores implementing Strategy B is as follows:

Count = 20

R-squared = 0.692

Adjusted R-squared = 0.651

Coefficient    Std Error t-value p-value   
Intercept 94,440 8,200 7.04 0.01
Strategy implementation score    10,099 1,031 9.28 0.01
Experience score 3,228 546 4.00 0.01
Market size 0.672 0.100 2.10 0.05
Customer satisfaction 31,094 3,652 2.95 0.03

Required

1. Suppose you are making a prediction about financial profit for a future month, based on the analysis from Strategy A. What would your next step be in relying on regression analysis to assess the effectiveness of Strategy A?

2. Suppose you are making a prediction about financial profit for a future month based on the analysis from Strategy B. What would be your prediction based on a store with the following characteristics:

  • Strategy implementation score = 83

  • Experience score = 9.2

  • Market size = 20,000

  • Customer satisfaction rating = 8

3. In interpreting and/or relying on regression analysis (in general), what qualitative concerns should Nordique managers consider?

Solutions

Expert Solution

Sol:

For strategy A regression equation for predicting profit

profit=101452+9659*Strategy implementation score +4500*Experience score+0.453*market size+25403*customer satsifaction

For strategy B regression equation for predicting profit
profit=94440+10099*Strategy implementation score +3228*Experience score+0.672 *market size+31094*customer satsifaction

Prediction scores for strategy A

profit=101452+9659*Strategy implementation score +4500*Experience score+0.453*market size+25403*customer satsifaction

profit=101452+9659*83 +4500*9.2+0.453*20000+25403*8

=1156833

Prediction scores for strategy B

profit=94440+10099*Strategy implementation score +3228*Experience score+0.672 *market size+31094*customer satsifaction

profit=94440+10099*83 +3228*9.2+0.672 *20000+31094*8

=1224547

In interpreting and/or relying on regression analysis (in general), what qualitative concerns should Nordique managers consider?

R sq

here rs qfor both model is

R sq=0.692

=69.2% variation in profit is explained by model

Overall F test for the model

Indivudual t tests for slopes.

For sttargey A

For startegy B

startegy B is best as all are signficant variables at 5% and R sq=69.2%


Related Solutions

a) Indigo Inc. has $581,180 to invest. The company is trying to decide between two alternative...
a) Indigo Inc. has $581,180 to invest. The company is trying to decide between two alternative uses of the funds. One alternative provides $77,120 at the end of each year for 12 years, and the other is to receive a single lump-sum payment of $1,823,990 at the end of the 12 years. Which alternative should Indigo select? Assume the interest rate is constant over the entire investment. b) Indigo Inc. has completed the purchase of new Dell computers. The fair...
(1) Wildhorse Inc. has $574,100 to invest. The company is trying to decide between two alternative...
(1) Wildhorse Inc. has $574,100 to invest. The company is trying to decide between two alternative uses of the funds. One alternative provides $80,173 at the end of each year for 12 years, and the other is to receive a single lump-sum payment of $1,801,773 at the end of the 12 years. Which alternative should Wildhorse select? Assume the interest rate is constant over the entire investment. ALTERNATE ONE    OR      ALTERNATE TWO (2) Wildhorse Inc. has completed the purchase of...
Lizzy, a strategic planner at Wild Products, is trying to decide which product to make and...
Lizzy, a strategic planner at Wild Products, is trying to decide which product to make and sell over the next 5 years. Lizzy gets a raise based on her company’s Return on Investment which has been more that 18% in the last 3 years. Below are the cost and revenue projections for each product: Discount rate: 16%                                                                                                                 Gadgets                                               Widgets Initial Investment:                                                                           Cost of Equipment (zero salvage value)                                  $170,000                                              $380,000              Annual revenues and costs: Sales Revenue                                                                                  $250,000                                              $350,000 Variable...
Without trying to decide who will win if Veronica sues Fun Products, Inc. and the Milton...
Without trying to decide who will win if Veronica sues Fun Products, Inc. and the Milton Hotel chain, analyze the following. Who are the parties to this lawsuit, and what are they called (trial level and appeal level)? What types of law will Veronica's lawsuit involve? What type of remedies is she seeking, and are these remedies (or some of them) appropriate to this type of case? What legal sources will the court consider in deciding if Fun Products, Inc....
Your company is trying to decide which one of two projects it should accept. Both projects...
Your company is trying to decide which one of two projects it should accept. Both projects have the same start-up costs. Project 1 will produce annual cash flows of $52 000 at the end of each year for six years. Project 2 will produce cash flows of $39 000 at the beginning of each year for eight years. The company requires a 15% return. Required: a. Whichprojectshouldthecompanyselectandwhy? b. Whichprojectshouldthecompanyselectiftheinterestrateis12%atthe cash flows in Project 2 is also at the end of...
when a company is trying to decide on which capitalization option is best for the company...
when a company is trying to decide on which capitalization option is best for the company why are the following three important? Company’s capital structure, Company’s working capital and Asset performance of the company. ​
If you are trying to address and further implement certain strategies for a specific public health...
If you are trying to address and further implement certain strategies for a specific public health issue in a community, what are some of the examples of multiple social and political forces you might be faced with? In other words, what kinds of community politics could you encounter?
The University is trying to decide whether to implement a mandatory remedial math course for students...
The University is trying to decide whether to implement a mandatory remedial math course for students with low test scores upon admissions. Historically, students with low admissions test scores have failed their first math course 61% of the time. A random sample of students with low scores is selected and assigned to a remedial math course. These students are tracked and it is found that 102 out of 175 of them still fail their first regular math course.             If...
Labeau Products, Ltd., of Perth, Australia, has $12,000 to invest. The company is trying to decide...
Labeau Products, Ltd., of Perth, Australia, has $12,000 to invest. The company is trying to decide between two alternative uses for the funds as follows: Invest in Project X Invest in Project Y Investment required $ 12,000 $ 12,000 Annual cash inflows $ 4,000 Single cash inflow at the end of 6 years $ 28,000 Life of the project 6 years 6 years The company’s discount rate is 16%. Click here to view Exhibit 13B-1 and Exhibit 13B-2, to determine...
Labeau Products, Ltd., of Perth, Australia, has $26,000 to invest. The company is trying to decide...
Labeau Products, Ltd., of Perth, Australia, has $26,000 to invest. The company is trying to decide between two alternative uses for the funds as follows: Invest in Project X Invest in Project Y Investment required $ 26,000 $ 26,000 Annual cash inflows $ 8,000 Single cash inflow at the end of 6 years $ 50,000 Life of the project 6 years 6 years The company’s discount rate is 12%. Click here to view Exhibit 13B-1 and Exhibit 13B-2, to determine...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT