Using regression analysis, determine the relationship between R&D expenditures and sales revenue.
Data: Lab 5.1 Data.xlsx
Specify the Question: Does regression analysis explain the relationship between R&D expenditures and sales revenue?
Obtain the Data: Open Excel file Lab 5.1 Data.xlsx and browse around a bit.
Analyze the Data: Refer to lab 5.1 in your text for additional instructions and steps.
Part 1
Upload one Word or PDF document containing all of your screenshots for this Lab using the button below.
Note: Please submit your file attachment response in one of the approved file formats; Word file (.doc or .docx), Excel file (.xls or .xlsx), or PDF. To submit photo or image files please paste them into Word or PDF. Consult with your instructor as needed on their preferred file attachment format.
Take a screenshot of the scatterplot of the relationship between R&D expenditures and revenues, paste it into a Word document named Lab 5.1 Submission.docx, and label the screenshot Submission 1.
Take a screenshot of the regression output predicting revenues, paste it into the same Word document, and label the screenshot Submission 2. Part 2: Answer the following questions based on the details computed. Note: Round the adjusted R-squared value to 1 decimal place. (See Attached) Part 3 Submit your answers for the following Analysis Questions in the text entry field below.
Why would you expect R&D expenditures to be associated with the level of current or future sales?
Given the coefficient on R&D expenditures, $1 in additional R&D expenditures is associated with what level of revenue? In other words, what is the multiple?
