Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1 0 - 4 6 . INTERPRETING REGRESSION RESULTS, MATCHING TIME PERIODS. Nandita Summers works at Modus, a store that caters to fashion for young

10-46. INTERPRETING REGRESSION RESULTS, MATCHING TIME PERIODS. Nandita Summers works at Modus, a store that caters to fashion for young adults. Nandita is responsible for the stores online advertising and promotion budget. For the past year, she has studied search engine optimization and has been purchasing keywords and display advertising on Google, Facebook, and Twitter. In order to analyze the effectiveness of her efforts and to decide whether to continue online advertising or move her advertising dollars back to traditional print media, Nandita collects the following data:OnlineSalesMonthAdvertising ExpenseRevenueSeptember$5,125$44,875October 5,47242,480November 3,94253,106December 1,44064,560January 4,91934,517February 4,14259,438March 1,29051,840April 5,72236,720May 5,73062,564June 2,21459,568July 1,71635,450August 1,87536,211 Required4161. Nandita performs a regression analysis, comparing each months online advertising expense with that months revenue. Verify that she obtains the following result:VariableCoefficientStandard Errort-ValueConstant$51,999.647,988.686.51Independent variable: Online advertising expense; Durbin@Watson statistic =2.141.992. Plot the preceding data on a graph and draw the regression line. What does the cost formula indicate about the relationship between monthly online advertising expense and monthly sales revenue? Is the relationship economically plausible?3. After further thought, Nandita realizes there may have been a flaw in her approach. In particular, there may be a lag between the time customers click through to the Modus website and peruse its social media content (which is when the online ad expense is incurred) and the time they actually shop in the physical store. Nandita modifies her analysis by comparing each months sales revenue to the advertising expense in the prior month. After discarding September sales revenue and August advertising expense, show that the modified regression yields the following: VariableCoefficientStandard Errort-ValueConstant$28,361.375,428.695.22Independent variable: Previous months online advertising expense; Durbin-Watson statistic =1.715.381.314.124. What does the revised formula indicate? Plot the revised data on a graph. Is this relationship economically plausible?5. Can Nandita conclude that there is a cause-and-effect relationship between online advertising expense and sales revenue? Why or why not?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting And Reporting

Authors: Mr Barry Elliott, Jamie Elliott

16th Edition

027377817X, 978-0273778172

More Books

Students also viewed these Accounting questions

Question

Why are earnings per share and price-earnings ratios important?

Answered: 1 week ago

Question

=+ How do some of them single you out when you're the consumer?

Answered: 1 week ago