Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

please help me understand. A video media consultant collected the following data on popular LED televisions soid through on-line retailers. Click here foc the Excel

please help me understand.
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
A video media consultant collected the following data on popular LED televisions soid through on-line retailers. Click here foc the Excel Data File a. Does there oppear to be a linear relationship between the screen size and the price? (Round your answer to 2 decimal places.) Click here for the Excel Data File a. Does there appear to be a linear relationship between the screen size and the price? (Round your answer to 2 decimal places.) b. Which variable is the "dependent" variable? Screen size Price c-1. Use statistical software to determine the regression equation. (Negative amounts should be indicated by a minus sign. Round your answers to 3 decimal places.) c-2. Interpret the value of the slope in the regression equation. (Round your answer to 3 decimal places.) d. Include the two qualitative variables, "Sony" and "Sharp", as "dummy" variables in the multiple regression analysis. Note: if both "Sony" and "Sharp", are equal to zero, then the manufacturer is Samsung: if "Sony" =1 and "Sharp" =0, then the manufacturer is Sony: ; If "Sony" =0 and "Sharp" =1, then the manufacturer is Sharp. (Negative amounts should be indicated by a minus sign. Round your answers to 3 decimal places.) e. Test each of the individual coefficients to see if they are significant. (Negative amounts should be indicated by a minus sign. Round your t-value to 2 decimal places and p-value to 4 decimal places.)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Students also viewed these Accounting questions