Question

In: Statistics and Probability

Great Plains Distributors, Inc. sells roofing and siding products to home improvement retailers, such as Lowe’s...

Great Plains Distributors, Inc. sells roofing and siding products to home improvement retailers, such as Lowe’s and Home Depot, and commercial contractors. The owner is interested in studying the effects of several variables on the sales volume of fiber-cement siding products.

The company has 26 marketing districts across the United States. In each district, it collected information on the following variables: sales volume (in thousands of dollars), advertising dollars (in thousands), number of active accounts, number of competing brands, and a rating of market potential.

Sales (000s) Advertising Dollars (000s) Number of Accounts Number of Competitors Market Potential
79.3 5.5 31 10 8
200.1 2.5 55 8 6
163.2 8.0 67 12 9
200.1 3.0 50 7 16
146.0 3.0 38 8 15
177.7 2.9 71 12 17
30.9 8.0 30 12 8
291.9 9.0 56 5 10
160.0 4.0 42 8 4
339.4 6.5 73 5 16
159.6 5.5 60 11 7
86.3 5.0 44 12 12
237.5 6.0 50 6 6
107.2 5.0 39 10 4
155.0 3.5 55 10 4
291.4 8.0 70 6 14
100.2 6.0 40 11 6
135.8 4.0 50 11 8
223.3 7.5 62 9 13
195.0 7.0 59 9 11
73.4 6.7 53 13 5
47.7 6.1 38 13 10
140.7 3.6 43 9 17
93.5 4.2 26 8 3
259.0 4.5 75 8 19
331.2 5.6 71 4 9

Conduct a multiple regression analysis to find the best predictors of sales.

1. Determine the regression equation by omitting the potential variable. (Negative amounts should be indicated by a minus sign. Round the constant value to the nearest whole number and rest of the values to 2 decimal values.)

Sales = ____ + ____ advertising + _______ accounts + ________ competitors

2. Complete the following table. (Negative amounts should be indicated by a minus sign. Leave no cells blank - be certain to enter "0" wherever required. Round your answers to 2 decimal places.)

Predictor Coefficient SE Coefficient t p-value
Constant
Advertising
Accounts
Competitors

3. Determine the regression equation by omitting the advertising variable. (Negative amounts should be indicated by a minus sign. Round your constant value to the nearest whole number and the rest of the values to 2 decimal places.)

Sales = ______ + ______ accounts + _______ competitors

4. Complete the following table. (Leave no cells blank - be certain to enter "0" wherever required. Negative amounts should be indicated by a minus sign. Round your Coef, SE Coef and t-values to 2 decimal places.)

Predictor Coefficient SE Coefficient t p-value
Constant
Accounts
Competitors

5. Compute the variance inflation factor for the independent variables.

Variance inflation _______

Solutions

Expert Solution



Related Solutions

Great Plains Roofing and Siding Company, Inc., sells roofing and siding products to home repair retailers,...
Great Plains Roofing and Siding Company, Inc., sells roofing and siding products to home repair retailers, such as Lowe’s and Home Depot, and commercial contractors, the owner is interested in studying the effects of several variables on the value of singles sold($000). The marketing manager is arguing that the company should spend more money on advertising, while a market researcher suggests it should focus more on making its brand and product more distinct from its competitors. The company has divided...
Great Plains Roofing and Siding Company, Inc., sells roofing and siding products to home repair retailers,...
Great Plains Roofing and Siding Company, Inc., sells roofing and siding products to home repair retailers, such as Lowe’s and Home Depot, and commercial contractors, the owner is interested in studying the effects of several variables on the value of singles sold($000). The marketing manager is arguing that the company should spend more money on advertising, while a market researcher suggests it should focus more on making its brand and product more distinct from its competitors. The company has divided...
A Roofing and Siding company sells its products to home repair retailers. The owner is interested...
A Roofing and Siding company sells its products to home repair retailers. The owner is interested in studying the effects of several variables on the value of shingles sold ($000). The marketing manageris arguing that the company shpuld spend more money on   advertising, while a market researcher suggests it should focus more on making its brand and product more distinct from its competitors. The company has divided the United States into 26 marketing districts. In each district, it collected information...
Lowe’s is a leading retailer in the home improvement field. Complete the component percentage analysis on...
Lowe’s is a leading retailer in the home improvement field. Complete the component percentage analysis on the company’s income statement that follows. (Enter your answer as a percentage rounded to 2 decimal place (i.e. 0.1234 should be entered as 12.34).) LOWE’S COMPANIES, INC. Consolidated Statements of Earnings (in millions, except per share and percentage data) Fiscal Years Ended on February 3, 2012 % Sales January 28, 2011 % Sales January 29, 2010 % Sales Net sales $48,249 100.00 % $48,291...
Brooks Plumbing Products Inc. (BPP) manufactures plumbing fixtures and other home improvement products that are sold...
Brooks Plumbing Products Inc. (BPP) manufactures plumbing fixtures and other home improvement products that are sold in Home Depot and Walmart as well as hardware stores. BPP has a solid reputation for providing value products, good quality, and a good price. The company has been approached by an investment banking firm representing a third company, Garden Specialties Inc. (GSI), that is interested in acquiring BPP. The acquiring firm (GSI) is a retailer of garden supplies; it sees the potential synergies...
Sweet Home Improvement Company installs replacement siding, windows, and louvered glass doors for single-family homes and...
Sweet Home Improvement Company installs replacement siding, windows, and louvered glass doors for single-family homes and condominium complexes. The company is in the process of preparing its annual financial statements for the fiscal year ended May 31, 2020. Jim Alcide, controller for Sweet, has gathered the following data concerning inventory. At May 31, 2020, the balance in Sweet’s Raw Materials Inventory account was $485,520, and Allowance to Reduce Inventory to NRV had a credit balance of $27,670. Alcide summarized the...
Whispering Home Improvement Company installs replacement siding, windows, and louvered glass doors for single-family homes and...
Whispering Home Improvement Company installs replacement siding, windows, and louvered glass doors for single-family homes and condominium complexes. The company is in the process of preparing its annual financial statements for the fiscal year ended May 31, 2020. Jim Alcide, controller for Whispering, has gathered the following data concerning inventory. At May 31, 2020, the balance in Whispering’s Raw Materials Inventory account was $424,320, and Allowance to Reduce Inventory to NRV had a credit balance of $27,440. Alcide summarized the...
Pharoah Home Improvement Company installs replacement siding, windows, and louvered glass doors for single-family homes and...
Pharoah Home Improvement Company installs replacement siding, windows, and louvered glass doors for single-family homes and condominium complexes. The company is in the process of preparing its annual financial statements for the fiscal year ended May 31, 2020. Jim Alcide, controller for Pharoah, has gathered the following data concerning inventory. At May 31, 2020, the balance in Pharoah’s Raw Materials Inventory account was $456,960, and Allowance to Reduce Inventory to Market had a credit balance of $28,300. Alcide summarized the...
Sunland Home Improvement Company installs replacement siding, windows, and louvered glass doors for single-family homes and...
Sunland Home Improvement Company installs replacement siding, windows, and louvered glass doors for single-family homes and condominium complexes. The company is in the process of preparing its annual financial statements for the fiscal year ended May 31, 2020. Jim Alcide, controller for Sunland, has gathered the following data concerning inventory. At May 31, 2020, the balance in Sunland’s Raw Materials Inventory account was $505,920, and Allowance to Reduce Inventory to NRV had a credit balance of $27,630. Alcide summarized the...
Pharoah Home Improvement Company installs replacement siding, windows, and louvered glass doors for single-family homes and...
Pharoah Home Improvement Company installs replacement siding, windows, and louvered glass doors for single-family homes and condominium complexes. The company is in the process of preparing its annual financial statements for the fiscal year ended May 31, 2020. Jim Alcide, controller for Pharoah, has gathered the following data concerning inventory. At May 31, 2020, the balance in Pharoah’s Raw Materials Inventory account was $428,400, and Allowance to Reduce Inventory to Market had a credit balance of $26,750. Alcide summarized the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT