Project 3-Consumer Research

profilenarranitin9
Projectthreesampleworkbook.xlsx
Home>Business & Finance homework help>Accounting homework help>Project 3-Consumer Research

Data

Income ($1000s) Household Size Amount Charged ($)
54 3 4,016
30 2 3,159
32 4 5,100
50 5 4,742
31 2 1,864
55 2 4,070
37 1 2,731
40 2 3,348
66 4 4,764
51 3 4,110
25 3 4,208
48 4 4,219
27 1 2,477
33 2 2,514
65 3 4,214
63 4 4,965
42 6 4,412
21 2 2,448
44 1 2,995
37 5 4,171
62 6 5,678
21 3 3,623
55 7 5,301
42 2 3,020
41 7 4,828
54 6 5,573
30 1 2,583
48 2 3,866
34 5 3,586
67 4 5,037
50 2 3,605
67 5 5,345
55 6 5,370
52 2 3,890
62 3 4,705
64 2 4,157
22 3 3,579
29 4 3,890
39 2 2,972
35 1 3,121
39 4 4,183
54 3 3,730
23 6 4,127
27 2 2,921
26 7 4,603
61 2 4,273
30 2 3,067
22 4 3,074
46 5 4,820
66 4 5,149

Descriptive Statistics

Income ($1000s) Household Size Amount Charged ($) Income ($1000s)
54 3 4,016 Similarly you will get the descriptive statistics for the other two variables " Household Size" & "Amount Charges"
30 2 3,159 Mean 43.48
32 4 5,100 Standard Error 2.0577856139
50 5 4,742 Median 42
31 2 1,864 Mode 54
55 2 4,070 Standard Deviation 14.550741618
37 1 2,731 Sample Variance 211.7240816327
40 2 3,348 Kurtosis -1.2477194221
66 4 4,764 Skewness 0.0958556386
51 3 4,110 Range 46
25 3 4,208 Minimum 21
48 4 4,219 Maximum 67
27 1 2,477 Sum 2174
33 2 2,514 Count 50
65 3 4,214 Confidence Level(95.0%) 4.135275013
63 4 4,965
42 6 4,412
21 2 2,448
44 1 2,995
37 5 4,171
62 6 5,678
21 3 3,623
55 7 5,301
42 2 3,020
41 7 4,828
54 6 5,573
30 1 2,583
48 2 3,866
34 5 3,586
67 4 5,037
50 2 3,605
67 5 5,345
55 6 5,370
52 2 3,890
62 3 4,705
64 2 4,157
22 3 3,579
29 4 3,890
39 2 2,972
35 1 3,121
39 4 4,183
54 3 3,730
23 6 4,127
27 2 2,921
26 7 4,603
61 2 4,273
30 2 3,067
22 4 3,074
46 5 4,820
66 4 5,149

Simple Regression-income

Income ($1000s) Household Size Amount Charged ($) Simple regression - Income
54 3 4,016 SUMMARY OUTPUT
30 2 3,159
32 4 5,100 Regression Statistics
50 5 4,742 Multiple R
31 2 1,864 R Square
55 2 4,070 Adjusted R Square
37 1 2,731 Standard Error
40 2 3,348 Observations
66 4 4,764
51 3 4,110 ANOVA
25 3 4,208 df SS MS F Significance F <- Output from " Regression" in "Data Analysis ToolPak"
48 4 4,219 Regression
27 1 2,477 Residual
33 2 2,514 Total
65 3 4,214
63 4 4,965 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
42 6 4,412 Intercept
21 2 2,448 Income ($1000s)
44 1 2,995
37 5 4,171
62 6 5,678 Scatter plot: Amount of charge vs. Income
21 3 3,623
55 7 5,301 Your scatter plot here!
42 2 3,020
41 7 4,828
54 6 5,573
30 1 2,583
48 2 3,866
34 5 3,586
67 4 5,037
50 2 3,605
67 5 5,345
55 6 5,370
52 2 3,890
62 3 4,705
64 2 4,157
22 3 3,579
29 4 3,890
39 2 2,972
35 1 3,121
39 4 4,183
54 3 3,730
23 6 4,127
27 2 2,921
26 7 4,603
61 2 4,273
30 2 3,067
22 4 3,074
46 5 4,820
66 4 5,149

Simple Regression- size

Income ($1000s) Household Size Amount Charged ($) Simple regression - Household Size
54 3 4,016 SUMMARY OUTPUT
30 2 3,159
32 4 5,100 Regression Statistics
50 5 4,742 Multiple R
31 2 1,864 R Square
55 2 4,070 Adjusted R Square
37 1 2,731 Standard Error
40 2 3,348 Observations
66 4 4,764
51 3 4,110 ANOVA
25 3 4,208 df SS MS F Significance F <- Output from " Regression" in "Data Analysis ToolPak"
48 4 4,219 Regression
27 1 2,477 Residual
33 2 2,514 Total
65 3 4,214
63 4 4,965 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
42 6 4,412 Intercept
21 2 2,448 Household Size
44 1 2,995
37 5 4,171
62 6 5,678 Scatter plot: Amount of charge vs. Size
21 3 3,623
55 7 5,301 Your scatter plot here!
42 2 3,020
41 7 4,828
54 6 5,573
30 1 2,583
48 2 3,866
34 5 3,586
67 4 5,037
50 2 3,605
67 5 5,345
55 6 5,370
52 2 3,890
62 3 4,705
64 2 4,157
22 3 3,579
29 4 3,890
39 2 2,972
35 1 3,121
39 4 4,183
54 3 3,730
23 6 4,127
27 2 2,921
26 7 4,603
61 2 4,273
30 2 3,067
22 4 3,074
46 5 4,820
66 4 5,149

Multiple Regression

Income ($1000s) Household Size Amount Charged ($) Multiple Regression output:
54 3 4,016 SUMMARY OUTPUT
30 2 3,159
32 4 5,100 Regression Statistics
50 5 4,742 Multiple R
31 2 1,864 R Square
55 2 4,070 Adjusted R Square
37 1 2,731 Standard Error
40 2 3,348 Observations
66 4 4,764
51 3 4,110 ANOVA <- Output from " Regression" in "Data Analysis ToolPak"
25 3 4,208 df SS MS F Significance F
48 4 4,219 Regression
27 1 2,477 Residual
33 2 2,514 Total
65 3 4,214
63 4 4,965 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
42 6 4,412 Intercept
21 2 2,448 Income ($1000s)
44 1 2,995 Household Size
37 5 4,171
62 6 5,678
21 3 3,623
55 7 5,301
42 2 3,020
41 7 4,828
54 6 5,573
30 1 2,583 Now let size = 3, income = 40000, then what is the annual credit charge?
48 2 3,866
34 5 3,586
67 4 5,037
50 2 3,605
67 5 5,345
55 6 5,370
52 2 3,890
62 3 4,705
64 2 4,157
22 3 3,579
29 4 3,890
39 2 2,972
35 1 3,121
39 4 4,183
54 3 3,730
23 6 4,127
27 2 2,921
26 7 4,603
61 2 4,273
30 2 3,067
22 4 3,074
46 5 4,820
66 4 5,149

Residual Analysis

Income ($1000s) Household Size Amount Charged ($) Multiple Regression output:
54 3 4,016 SUMMARY OUTPUT
30 2 3,159
32 4 5,100 Regression Statistics
50 5 4,742 Multiple R
31 2 1,864 R Square
55 2 4,070 Adjusted R Square
37 1 2,731 Standard Error
40 2 3,348 Observations
66 4 4,764
51 3 4,110 ANOVA
25 3 4,208 df SS MS F Significance F
48 4 4,219 Regression
27 1 2,477 Residual
33 2 2,514 Total
65 3 4,214
63 4 4,965 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
42 6 4,412 Intercept
21 2 2,448 Income ($1000s)
44 1 2,995 Household Size
37 5 4,171
62 6 5,678
21 3 3,623
55 7 5,301 RESIDUAL OUTPUT
42 2 3,020
41 7 4,828 Observation Predicted Amount Charged ($) Residuals Standard Residuals
54 6 5,573 1 4162.9749776183 -146.9749776183 -0.3769729141
30 1 2,583 2 3011.4868565585 147.5131434415 0.3783532439
48 2 3,866 3 3790.3446778375 1309.6553221625 3.3591063679 >=2
34 5 3,586 4 4743.0347440051 -1.0347440051 -0.0026539923
67 4 5,037 5 3044.6198657072 -1180.6198657072 -3.0281461404
50 2 3,605 6 3839.8120852762 230.1879147238 0.5904039613
67 5 5,345 7 2887.1220191086 -156.1220191086 -0.4004339613
55 6 5,370 8 3342.8169480455 5.1830519545 0.0132938969
52 2 3,890 9 4916.8669888936 -152.8669888936 -0.3920852053
62 3 4,705 10 4063.5759501721 46.4240498279 0.1190720327
64 2 4,157 11 3202.1177123057 1005.8822876943 2.5799655381 >= 2
22 3 3,579 12 4320.4728242168 -101.4728242168 -0.2602654334
29 4 3,890 13 2555.7919276215 -78.7919276215 -0.2020916964
39 2 2,972 14 3110.8858840046 -596.8858840046 -1.5309395838
35 1 3,121 15 4527.4380782541 -313.4380782541 -0.8039304898
39 4 4,183 16 4817.4679614474 147.5320385526 0.3784017075
54 3 3,730 17 4834.2665723062 -422.2665723062 -1.0830623203
23 6 4,127 18 2713.2897742201 -265.2897742201 -0.6804359551
27 2 2,921 19 3119.0530831496 -124.0530831496 -0.318181047
26 7 4,603 20 4312.3056250719 -141.3056250719 -0.3624317154
61 2 4,273 21 5496.9267552804 181.0732447196 0.4644308156
30 2 3,067 22 3069.5856757109 553.4143242891 1.4194403286
22 4 3,074 23 5621.2915927302 -320.2915927302 -0.8215089196
46 5 4,820 24 3409.082966343 -389.082966343 -0.9979504132
66 4 5,149 25 5157.4294646483 -329.4294646483 -0.8449464479
26 5231.8626820907 341.1373179093 0.8749756654
27 2655.1909550677 -72.1909550677 -0.1851610059
28 3607.8810212352 258.1189787648 0.6620437382
29 4212.9065976257 -626.9065976257 -1.6079390574
30 4949.9999980423 87.0000019577 0.2231444073
31 3674.1470395326 -69.1470395326 -0.1773537334
32 5306.2958995331 38.7041004669 0.099271303
33 5264.9956912394 105.0043087606 0.2693232611
34 3740.41305783 149.58694217 0.383672285
35 4428.0390508079 276.9609491921 0.7103710972
36 4138.0091676145 18.9908323855 0.0487091717
37 3102.7186848596 476.2813151404 1.2216035559
38 3690.9456503914 199.0543496086 0.5105501593
39 3309.6839388968 -337.6839388968 -0.8661181689
40 2820.8560008112 300.1439991888 0.7698327964
41 4022.2757418785 160.7242581215 0.4122381437
42 4162.9749776183 -432.9749776183 -1.1105280755
43 4204.7393984808 -77.7393984808 -0.1993920874
44 2912.0878291123 8.9121708877 0.0228586327
45 4660.4343274177 -57.4343274177 -0.1473120536
46 4038.6101401684 234.3898598316 0.6011814387
47 3011.4868565585 55.5131434415 0.1423844507
48 3459.0145863504 -385.0145863504 -0.9875155141
49 4610.5027074102 209.4972925898 0.5373350359
50 4916.8669888936 232.1330111064 0.5953928966

image1.png