A Retailer Recorded Its Weekly Sales Data For A Particular Product In Addition It Also Recorded Its Own Advertising Ex 1 (300.94 KiB) Viewed 89 times
1.
A Retailer Recorded Its Weekly Sales Data For A Particular Product In Addition It Also Recorded Its Own Advertising Ex 2 (38.38 KiB) Viewed 89 times
2.
A Retailer Recorded Its Weekly Sales Data For A Particular Product In Addition It Also Recorded Its Own Advertising Ex 3 (47.37 KiB) Viewed 89 times
A retailer recorded its weekly sales data for a particular product. In addition, it also recorded its own advertising expenditure and its competitor's price for the same product in the same week. The data file can be found here (Sales pricing advertising data.xlsx ). Use Excel's Regression tool to determine the relationship between independent variables price, advertising, and dependent variable sales. According to the information, answer the following two questions. Use a = 0.01. Week Price Advertising Sales 1 0.33 5 2 0.25 2 14 3 0.44 7 4 0.4 9 3 4 3 4 ? ? 3 3 5 0.35 16 6 0.39 7 0.29 9 15 8 0.46 6 9 0.25 15 10 0.31 7 18
According to your Excel output, which factor(s) is significantly related to sales? neither advertising nor competitor's price O both advertising and competitor's price O advertising only competitor's price only
Given advertising = 8 and competitor's price = 0.35, what is the predicted sales? Keep 2 decimals.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!