Question
Is the price of a smartphone affected by its battery life, display size, or camera resolution? Perform a regression analysis on the SmartphonesBDC.xlsx dataset using
Is the price of a smartphone affected by its battery life, display size, or camera resolution? Perform a regression analysis on the SmartphonesBDC.xlsx dataset using MegaStat and answer the following questions. The level of significance is .05. When you copy and paste output from MegaStat to answer a question, remember to choose to "Keep Formatting" to paste the text.
a. Do the data conform to Evans' Rule? What about Doane's Rule? Explain the reason for your answers.
b. What is the critical value for the F test?
c. Perform the regression and state the regression equation.
d. Copy and paste the ANOVA table from your analysis. Is the overall fit of the model significant or not? Explain your reasoning.
e. What is the coefficient of determination and the adjusted coefficient of determination for your analysis? What do these two coefficients tell you about the variation of price in your model?
Battery Life (Hours) 41 Display Diagonal Size (Inches) 6.7 Camera (Megapixels) 12 34 Price 1100 1000 500 700 800 600 12 12 27.5 28.5 32.5 28 6.1 6.1 5.4 6.1 6.1 12 12 12 12 400 1300 25.5 36.5 4.7 6.9 108 38 108 6.8 6.7 37 34 6.7 1200 1000 1000 700 800 500 500 12 12 12 6.5 38 30 6.2 6.5 12 64 45 43 6.7 64 Smartphone Apple iPhone 12 Pro Max Apple iPhone 12 Pro Apple iPhone XR Apple iPhone 12 mini Apple iPhone 12 Apple iPhone 11 Apple iPhone SE 2020 Samsung Galaxy Note20 Ultra 5G Samsung Galaxy S21 Ultra 5G Samsung Galaxy S21+ 5G Samsung Galaxy Note20 5G Samsung Galaxy S20 FE 5G Samsung Galaxy S21 5G Samsung Galaxy A52 5G Samsung Galaxy A71 56 Samsung Galaxy Z Fold2 56 Samsung Galaxy A4256 Samsung Galaxy A51 Samsung Galaxy A50 Samsung Galaxy Z Flip 5G Samsung Galaxy Z Flip OnePlus 8 Pro OnePlus 8 OnePlus Nord N10 5G OnePlus 9 Pro OnePlus 8T Sony Xperia 5 11 LG V60 ThinQ 5G Google Pixel 5 LG Velvet 5G Sony Xperia 1 11 Google Pixel 4a 29 12 7.6 6.6 48 1800 400 400 300 950 1200 700 500 300 49 39.5 34 27.5 17.5 6.4 6.4 48 25 12.2 12.2 6.7 6.7 6.8 34 48 38 48 6.6 6.5 41.5 64 1070 6.7 25 23.5 45 45 48 48 12 600 900 650 700 6.6 6.1 6.8 6.0 64 12.2 34 600 6.8 48 40 30.5 1000 12 6.5 58 350 325 122 350 5.8 380 210 500 32.5 41 48.5 30 6.7 6.5 6.4 12.2 48 13 12 700 34 6.7 64 6.6 Google Pixel 4a Motorola One 5G Ace OnePlus Nord N100 LG G8X ThinQ with Dual Screen Motorola Edge Motorola Moto g power (2021) Motorola Moto G Power Motorola Moto g stylus (2021) Motorola Moto G Stylus Sony Xperia 10 11 LG Wing 5G Motorola Moto G Play TCL 10L Motorola Razr 230 250 280 48 16 41.5 41 30.5 33 6.4 6.8 48 250 6.4 48 38 6.0 12 64 400 600 160 250 13 24.5 45.5 31 19.5 6.8 6.5 6.5 6.2 48 1300 16 Battery Life (Hours) 41 Display Diagonal Size (Inches) 6.7 Camera (Megapixels) 12 34 Price 1100 1000 500 700 800 600 12 12 27.5 28.5 32.5 28 6.1 6.1 5.4 6.1 6.1 12 12 12 12 400 1300 25.5 36.5 4.7 6.9 108 38 108 6.8 6.7 37 34 6.7 1200 1000 1000 700 800 500 500 12 12 12 6.5 38 30 6.2 6.5 12 64 45 43 6.7 64 Smartphone Apple iPhone 12 Pro Max Apple iPhone 12 Pro Apple iPhone XR Apple iPhone 12 mini Apple iPhone 12 Apple iPhone 11 Apple iPhone SE 2020 Samsung Galaxy Note20 Ultra 5G Samsung Galaxy S21 Ultra 5G Samsung Galaxy S21+ 5G Samsung Galaxy Note20 5G Samsung Galaxy S20 FE 5G Samsung Galaxy S21 5G Samsung Galaxy A52 5G Samsung Galaxy A71 56 Samsung Galaxy Z Fold2 56 Samsung Galaxy A4256 Samsung Galaxy A51 Samsung Galaxy A50 Samsung Galaxy Z Flip 5G Samsung Galaxy Z Flip OnePlus 8 Pro OnePlus 8 OnePlus Nord N10 5G OnePlus 9 Pro OnePlus 8T Sony Xperia 5 11 LG V60 ThinQ 5G Google Pixel 5 LG Velvet 5G Sony Xperia 1 11 Google Pixel 4a 29 12 7.6 6.6 48 1800 400 400 300 950 1200 700 500 300 49 39.5 34 27.5 17.5 6.4 6.4 48 25 12.2 12.2 6.7 6.7 6.8 34 48 38 48 6.6 6.5 41.5 64 1070 6.7 25 23.5 45 45 48 48 12 600 900 650 700 6.6 6.1 6.8 6.0 64 12.2 34 600 6.8 48 40 30.5 1000 12 6.5 58 350 325 122 350 5.8 380 210 500 32.5 41 48.5 30 6.7 6.5 6.4 12.2 48 13 12 700 34 6.7 64 6.6 Google Pixel 4a Motorola One 5G Ace OnePlus Nord N100 LG G8X ThinQ with Dual Screen Motorola Edge Motorola Moto g power (2021) Motorola Moto G Power Motorola Moto g stylus (2021) Motorola Moto G Stylus Sony Xperia 10 11 LG Wing 5G Motorola Moto G Play TCL 10L Motorola Razr 230 250 280 48 16 41.5 41 30.5 33 6.4 6.8 48 250 6.4 48 38 6.0 12 64 400 600 160 250 13 24.5 45.5 31 19.5 6.8 6.5 6.5 6.2 48 1300 16Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started