sold A consumer analyet olecdod the following data on the screen recenty at a la
ID: 2948368 • Letter: S
Question
sold A consumer analyet olecdod the following data on the screen recenty at a large retaller sizes of popular LCD tolevislons 1,719.00 1,011.50 2,519.50 890.00 2,624.50 2,829.00 1419.50 2,053.50 2,715.00 2,602.00 1,061.50 2,302.00 2,347.00 2,640.50 1,022.00 1,294.50 2,184.50 1,237.00 1336.00 2,366.00 ,811.00 2,716.00 2,553.50 38 Samaung 32 Sony Sharp 42 24 47 Samaung 55 36 46 45 26 48 47 50 31 Sharp Samsung 32 40 32 Samsung 46 35 43 41 a. Does there appear to be a linear relationship between the screen size and the price? (Round your answer to 2 decimal places.) (Click to select) The correlation of Screen and Price b. Which variable is the "dependent" variable? (Cick to select) 0-1. Use statistical software to determine the regression equation. (Negative amounts should be indicated by a minus sign. Round your answers to the nearest whole number) Screen. G-2. Interpret the value of the slope in the regression equation. For each inch (Click to select) in screen size, the price increases $ on average. d. Include the manufacturer in a multiple Snear regression analysis using a "dummy" variable. Does it price? Hint: You will need to use a set of appear that some manufacturers can command a premium ndicator variables. (Round your answers indicated by a minus sign.) Screen+ Manufacturer Sharp o. Test each of the indvidual coefficients to see if they are signficant (Round your answers to 2 decimal places. Leave no cells blank be certain to enter"O wherever required. Negative amounts should be indicated by a minus sign) Manufecturer Sharp Manufacturer SonyExplanation / Answer
As you included a link of excel data in your question description, I attempted to solve it in excel and I will be providing you steps for the same alongwith your required answers.
I firstly reproduced the data in the excel sheet. Then,
a) For determining linear relationship between Screen Size and Prices, "CORREL" function can be used. Using it is simple, =CORREL(select first data array, select second data array) and excel comes up that data is POSITIVELY correlated and is equal to 0.876.
b) This is a bit intuitive and obvious one. Independent variables are variables that are changed and manipulated by researchers to measure the effect of change in dependent variables and then compare it. Obviously, researcher would want to know what effect will the change in screen size will lead to a change in price rather than the effect that the change in price will lead to change in screen size.
Hence, PRICE is a dependent variable and Screen Size is independent variable.
c1) For this one, there will be a few easy steps:
i) Select the data and insert a scatterplot chart. Make sure to put Prices on Y-axis and Screen Size on X-axis.
ii) Right-click on any dot and select "Add Trendline..." In the dialogue box, tick the box of "Display Equation on chart".
The said equation will be displayed on the chart and it will be our regression equation and in this case, it is coming our to be Prices = - 781.1 + (68.426 * Screen).
c2) We can easily identify from the above mentioned regression equation that the slope 68.426.
This clearly implies that, for each inch INCREASE in screen size, the price increases $68.426 on average.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.