in the excel file you will find two tabs:
GSU Data 1 and GSU Data 2. For GSU Data1, obtain regression equation of Quantity (Q) on Price (P) and derive the equation in the form of y = Qx + Py + C, and the given x and y as values derived from the regression summary data, and C as the coeffitient of the regression from the same summary. Then interpret the results.
For GSU data 2 obtain regression equation of Quantity (Q) on Price (P) on Advert (A) on Distance (D), and derive the equation in the form of y = Qx + Py + Az + Db + C given x, y, z, b as values of derived from the regression summary data, and C as the coeffitient of the regression from the same summary. Interpret the results and C as the coeffitient of the regression from the same summary. Interpret the results
Please use the attached excel “Exam 2 Regression Analysis 9.19.2024” perfrom a regression analysis and support your analysis or conclusion using the regression you just executed. Please submit your answer sheet (file) in excel, title the excel with your name and upload the filoe in Bb. Please note that if your regression output is different from mine, it could be you used more data or omitted data given. Here is my feedback and observation:
