Statistics Assessment

xlsx

School

Northeastern State University *

*We aren’t endorsed by this school

Course

3933

Subject

Economics

Date

Feb 20, 2024

Type

xlsx

Pages

16

Uploaded by CaptainReindeerPerson1051

Report
Manufacturer Screen Size (inches) Price ($) Sharp 46 736.5 Samsung 52 1150 Samsung 46 895 Sony 40 625 Sharp 42 773.25 Samsung 46 961.25 Samsung 40 686 Sharp 37 574.75 Sharp 46 1000 Sony 40 722.25 Sony 52 1307.5 Samsung 32 373.75 Sharp 37 657.25 Sharp 32 426.75 Sharp 52 1389 Samsung 40 874.75 Sharp 32 517.5 Samsung 52 1475 Sony 40 954.25 Sony 52 1551.5 Sony 46 1303 Sony 46 1430.5 Sony 52 1717
30 35 40 45 0 200 400 600 800 1000 1200 1400 1600 1800 2000 Relationship Between Screen Size a Screen Size Price
50 55 and Price Price generally seems to increase as screen size increases. This p a direct positive relationship between screen size and prices for
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
proves that there is these televisions.
Screen Size (inches) Price ($) Screen Size (inches) 1 Price ($) 0.89253741 1 Correlation Coefficient 0.89253741 The Corre strong po screen siz increases
elation Coefficient is .8925. This is a ositive relationship. This means that ze strongly effects price and as screen size s so does price.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Screen Size (inches) Price ($) 46 736.5 52 1150 SUMMARY OUTPUT 46 895 40 625 Regression 42 773.25 Multiple R 46 961.25 R Square 40 686 Adjusted R Square 37 574.75 Standard Error 46 1000 Observations 40 722.25 52 1307.5 ANOVA 32 373.75 37 657.25 Regression 32 426.75 Residual 52 1389 Total 40 874.75 32 517.5 52 1475 Y Intercept 40 954.25 Screen Size 52 1551.5 46 1303 46 1430.5 52 1717 Projected Sales Ba Screen Size (In.) 30 31 32 33 34 35 36 37 38 39 This is a simple linear reg order correlation of .892 Based on this analysis it i increases by $50.67 for e It is recommended that T significant impact on sale
40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55
n Statistics 0.892537413310057 0.796623034158208 0.78693841673717 178.059004170037 23 df SS MS F 1 2607944.05627868 2607944.05627868 82.2565311075394 21 665805.188286534 31705.0089660254 22 3273749.24456522 Coefficients Standard Error t Stat P-value -1242.13404246212 245.730834552789 -5.05485624025453 0.0000526614 50.6708329766287 5.58692509053385 9.06953863807522 0.0000000104 ased on Screen Size Sales Price ($) $277.97 $328.64 $379.31 $429.98 $480.65 $531.32 $581.99 $632.66 $683.33 $734.00 gression model that was made to asses the relationship between screen size and price. This model explai 25. This means that 90% of the variation in price is explained by screen size. is recommended that TV Revolution utilize the regression equation below to predict TV sale prices in the every inch added to size. TV Revolution conduct a multivariate regression model factoring in brand of TV, picture quality, or sound es. Y'=-1242.13+50.67x Where X equals screen size
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
$784.67 $835.34 $886.01 $936.68 $987.35 $1,038.02 $1,088.69 $1,139.36 $1,190.03 $1,240.70 $1,291.37 $1,342.04 $1,392.71 $1,443.38 $1,494.05 $1,544.72
Significance F 0.0000000104 Lower 95% Upper 95% Lower 95.0% Upper 95.0% -1753.15928807458 -731.108796849651 -1753.159 -731.1088 39.052186208898 62.2894797443594 39.05219 62.28948 ins a significant amount of correlation with a zero e future. As seen by the table below price d system as well. These variables may also have a
Manufacturer Screen Size (inches) Price ($) 0 46 736.5 1 52 1150 SUMMARY OUTPUT 1 46 895 0 40 625 Regression 0 42 773.25 Multiple R 1 46 961.25 R Square 1 40 686 Adjusted R Square 0 37 574.75 Standard Error 0 46 1000 Observations 0 40 722.25 0 52 1307.5 ANOVA 1 32 373.75 0 37 657.25 Regression 0 32 426.75 Residual 0 52 1389 Total 1 40 874.75 0 32 517.5 1 52 1475 Intercept 0 40 954.25 Manufacturer 0 52 1551.5 Screen Size (inches) 0 46 1303 0 46 1430.5 0 52 1717 A multiple regression an model. The Adjusted R S simple regression mode follows. y'=
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
n Statistics 0.9011617410061 0.812092483453145 0.793301731798459 175.379886295919 23 df SS MS F 2 2658587.15422182 1329293.57711091 43.2176689031302 20 615162.090343393 30758.1045171696 22 3273749.24456522 Coefficients Standard Error t Stat P-value -1227.01875616979 242.320000411336 -5.06362972138882 0.0000593885 -102.117790156537 79.5831380690522 -1.28315862674241 0.2141068528 51.038005923001 5.51029768431459 9.26229558673098 0.0000000113 nalysis was conducted to test if the variable "Manufacturer" should be included in this regression model. Square coefficient in this model is .7933. This explains around 80% of the variation in price. This is a robu el excluding manufacturer as a variable. The zero order coefficient for that model is .8925. The multiple re =-1227.02+-102.11(x 1 )+51.04( Where x 1 =manufacturer and x 2 = screen size
Significance F 0.0000000549 Lower 95% Upper 95% -1732.48941956929 -721.548092770296 -268.125307187292 63.8897268742189 39.543726369967 62.5322854760349 . Screen Size and price are also variables in this ust model however it is not as robust as the egression equation related to this equation is as (x 2 )
The slope coefficient for the variable "Manufacturer" is -102.12. This indicates a negative relationship bet manufacturer variable is also not significant which can be found by the associated p-value of .214106852 screen size is 51.04 which is a positive relationship and is significant, because it has a p-value of .0000000 significance of the multiple regression model as a whole, it is not recommended that TV Revolution utilize
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
tween it and sales price. The 28. However the slope coefficient for 000113. Because of this and the low e this model.