For Denniswright Only

profilelken82
week_5_assignment_spreadsheet.xlsx
Home>Business & Finance homework help>Accounting homework help>For Denniswright Only

Raw Data

Size Usage Usage/Sq Ft
(kilowatt-hours
(square feet) (kilowatt-hours) per square foot)
Home 1 1,290 1,182 0.92
Home 2 1,350 1,172 0.87
Home 3 1,470 1,264 0.86
Home 4 1,600 1,493 0.93
Home 5 1,710 1,571 0.92
Home 6 1,840 1,711 0.93
Home 7 1,980 1,804 0.91
Home 8 2,230 1,840 0.83
Home 9 2,400 1,956 0.82
Home 10 2,710 2,007 0.74
Home 11 2,930 1,984 0.68
Home 12 3,000 1,960 0.65
Home 13 3,210 2,001 0.62
Home 14 3,240 1,928 0.60
Home 15 3,520 1,945 0.55

ChartDataSheet_

This worksheet contains values required for MegaStat charts.
Boxplot 2/28/2015 20:43.50
2 1290 0.5525568182
2 1655 0.6652332196
3 1655 0.6652332196
3 2230 0.8251121076
1 2230 0.8251121076
3 2230 0.8251121076
3 2965 0.9136950904
2 2965 0.9136950904
2 3520 0.933125
2 2965 0.9136950904
1 2965 0.9136950904
1 1655 0.6652332196
2 1655 0.6652332196
1 -2275 -0.080152393
3 -2275 -0.080152393
1 -310 0.2925404133
3 -310 0.2925404133
1 4930 1.2863878967
3 4930 1.2863878967
1 6895 1.6590807031
3 6895 1.6590807031
Dotplot 2/28/2015 20:43.50
1290 1 0.5525568182 1
1350 1 0.5950617284 1
1470 1 0.623364486 1
1600 1 0.6533333333 1
1710 1 0.6771331058 1
1840 1 0.7405904059 1
1980 1 0.815 1
2230 1 0.8251121076 1
2400 1 0.8598639456 1
2710 1 0.8681481481 1
2930 1 0.9111111111 1
3000 1 0.9162790698 1
3210 1 0.9187134503 1
3240 1 0.9298913043 1
3520 1 0.933125 1
NormalPlot 2/28/2015 20:43.50
1290 -1.5341205444
1350 -1.1503493804
1470 -0.887146559
1600 -0.6744897502
1710 -0.4887764111
1840 -0.318639364
1980 -0.1573106846
2230 0
2400 0.1573106846
2710 0.318639364
2930 0.4887764111
3000 0.6744897502
3210 0.887146559
3240 1.1503493804
3520 1.5341205444
NormalPlot 2/28/2015 20:43.50
0.5525568182 -1.5341205444
0.5950617284 -1.1503493804
0.623364486 -0.887146559
0.6533333333 -0.6744897502
0.6771331058 -0.4887764111
0.7405904059 -0.318639364
0.815 -0.1573106846
0.8251121076 0
0.8598639456 0.1573106846
0.8681481481 0.318639364
0.9111111111 0.4887764111
0.9162790698 0.6744897502
0.9187134503 0.887146559
0.9298913043 1.1503493804
0.933125 1.5341205444

Variables

Size (square feet) Usage (kilowatt-hours per square foot)
Home 1 1,290 0.92
Home 2 1,350 0.87
Home 3 1,470 0.86
Home 4 1,600 0.93
Home 5 1,710 0.92
Home 6 1,840 0.93
Home 7 1,980 0.91
Home 8 2,230 0.83
Home 9 2,400 0.82
Home 10 2,710 0.74
Home 11 2,930 0.68
Home 12 3,000 0.65
Home 13 3,210 0.62
Home 14 3,240 0.60
Home 15 3,520 0.55

Output

Week 5
Descriptive statistics
Size (square feet) Usage (kilowatt-hours per square foot)
count 15 15
mean 2,299 0.79
sample standard deviation 758 0.14
sample variance 573,827 0.02
minimum 1,290 0.55
maximum 3,520 0.93
range 2,230 0.38
sum 34,480.00 11.8193
sum of squares 87,291,600.00 9.5691
deviation sum of squares (SSX) 8,033,573.33 0.2560
population variance 535,571.56 0.0171
population standard deviation 731.83 0.1306
standard error of the mean 195.59 0.0349
confidence interval 95.% lower 1,915.32 0.7195
confidence interval 95.% upper 2,682.01 0.8564
margin of error 383.35 0.0684
z 1.96 1.96
confidence interval 95.% lower 1,879 0.71
confidence interval 95.% upper 2,718 0.86
margin of error 419 0.07
t(df = 14) 2.145 2.145
empirical rule
mean - 1s 1,541.15 0.6527
mean + 1s 3,056.18 0.9232
percent in interval (68.26%) 60.0% 66.7%
mean - 2s 783.64 0.5175
mean + 2s 3,813.69 1.0584
percent in interval (95.44%) 100.0% 100.0%
mean - 3s 26.13 0.3823
mean + 3s 4,571.21 1.1936
percent in interval (99.73%) 100.0% 100.0%
tolerance interval 99.73% lower 26.13 0.3823
tolerance interval 99.73% upper 4,571.21 1.1936
half-width 2,272.54 0.4057
skewness 0.18 -0.5162
kurtosis -1.48 -1.3419
coefficient of variation (CV) 32.95% 17.16%
1st quartile 1,655 0.67
median 2,230 0.83
3rd quartile 2,965 0.91
interquartile range 1,310 0.25
mode ERROR:#N/A ERROR:#N/A
low extremes 0 0
low outliers 0 0
high outliers 0 0
high extremes 0 0
suggested interval width 500.0 0.05
normal curve GOF
p-value .5134 .1889
chi-square(df=2) 1.333 3.333
E 3.000 3.000
O(-0.84) 4 4
O(-0.25) 3 2
O(+0.25) 2 1
O(+0.84) 2 3
O(inf.) 4 5
Stem and Leaf plot for Size (square feet)
stem unit = 1000
leaf unit = 100
Frequency Stem Leaf
3 1 2 3 4
4 1 6 7 8 9
2 2 2 4
2 2 7 9
3 3 0 2 2
1 3 5
15
Stem and Leaf plot for Usage (kilowatt-hours per square foot)
stem unit = 0.1
leaf unit = 0.01
Frequency Stem Leaf
2 5 5 9
1 6 2
2 6 5 7
1 7 4
0 7
2 8 1 2
2 8 5 6
5 9 1 1 1 2 3
15
2/28/2015 20:43.50 (2)
2/28/2015 20:43.50 (2)
2/28/2015 20:43.50 (1)
2/28/2015 20:43.50 (2)
Frequency Distribution - Quantitative
Size (square feet) cumulative
lower upper midpoint width frequency percent frequency percent
1,000 < 1,500 1,250 500 3 20.0 3 20.0
1,500 < 2,000 1,750 500 4 26.7 7 46.7
2,000 < 2,500 2,250 500 2 13.3 9 60.0
2,500 < 3,000 2,750 500 2 13.3 11 73.3
3,000 < 3,500 3,250 500 3 20.0 14 93.3
3,500 < 4,000 3,750 500 1 6.7 15 100.0
3999.99
15 100.0
Frequency Distribution - Quantitative
Usage (kilowatt-hours per square foot) cumulative
lower upper midpoint width frequency percent frequency percent
0.55 < 0.60 0.58 0.05 2 13.3 2 13.3
0.60 < 0.65 0.63 0.05 1 6.7 3 20.0
0.65 < 0.70 0.68 0.05 2 13.3 5 33.3
0.70 < 0.75 0.73 0.05 1 6.7 6 40.0
0.75 < 0.80 0.78 0.05 0 0.0 6 40.0
0.80 < 0.85 0.83 0.05 2 13.3 8 53.3
0.85 < 0.90 0.88 0.05 2 13.3 10 66.7
0.90 < 0.95 0.92 0.05 5 33.3 15 100.0
0.9499000000000004
15 100.0

BoxPlot

1290 1655 1655 2230 2230 2230 2965 2965 3520 2965 2965 1655 1655 2 2 3 3 1 3 3 2 2 2 1 1 2

Size (square feet)

0.55000000000000004 0.6 0.65 0.7 0.75 0.8 0.85 0.9 0.94990000000000041 13.333333333333334 6.666666666666667 13.333333333333334 6.666666666666667 0 13.333333333333334 13.333333333333334 33.333333333333329

Usage (kilowatt-hours per square foot)

Percent

1290 1350 1470 1600 1710 1840 1980 2230 2400 2710 2930 3000 3210 3240 3520 0.91627906976744189 0.86814814814814811 0.85986394557823131 0.93312499999999998 0.9187134502923977 0.92989130434782608 0.91111111111111109 0.82511210762331844 0.81499999999999995 0.740590405904059 0.67713310580204777 0.65333333333333332 0.62336448598130845 0.59506172839506177 0.55255681818181823

Size (square feet)

Usage (kilowatt-hours per square ft)

BoxPlot

0.55255681818181823 0.66523321956769055 0.66523321956769055 0.82511210762331844 0.82511210762331844 0.82511210762331844 0.91369509043927644 0.91369509043927644 0.93312499999999998 0.91369509043927644 0.91369509043927644 0.66523321956769055 0.66523321956769055 2 2 3 3 1 3 3 2 2 2 1 1 2

Usage (kilowatt-hours per square foot)

DotPlot

1290 1350 1470 1600 1710 1840 1980 2230 2400 2710 2930 3000 3210 3240 3520 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1

Size (square feet)

DotPlot

0.55255681818181823 0.59506172839506177 0.62336448598130845 0.65333333333333332 0.67713310580204777 0.740590405904059 0.81499999999999995 0.82511210762331844 0.85986394557823131 0.86814814814814811 0.91111111111111109 0.91627906976744189 0.9187134502923977 0.92989130434782608 0.93312499999999998 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1

Usage (kilowatt-hours per square foot)

Runs Plot

1290 1350 1470 1600 1710 1840 1980 2230 2400 2710 2930 3000 3210 3240 3520

Time

Size (square feet)

Runs Plot

0.91627906976744189 0.86814814814814811 0.85986394557823131 0.93312499999999998 0.9187134502923977 0.92989130434782608 0.91111111111111109 0.82511210762331844 0.81499999999999995 0.740590405904059 0.67713310580204777 0.65333333333333332 0.62336448598130845 0.59506172839506177 0.55255681818181823

Time

Usage (kilowatt-hours per square foot)

Normal Curve Plot

-1.5341205443525459 -1.1503493803760083 -0.88714655901887607 -0.67448975019608193 -0.48877641111466941 -0.3186393639643752 -0.1573106846101707 0 0.1573106846101707 0.3186393639643752 0.48877641111466941 0.67448975019608193 0.88714655901887607 1.1503493803760083 1.5341205443525465 1290 1350 1470 1600 1710 1840 1980 2230 2400 2710 2930 3000 3210 3240 3520

Normal Score

Size (square feet)

Normal Curve Plot

-1.5341205443525459 -1.1503493803760083 -0.88714655901887607 -0.67448975019608193 -0.48877641111466941 -0.3186393639643752 -0.1573106846101707 0 0.1573106846101707 0.3186393639643752 0.48877641111466941 0.67448975019608193 0.88714655901887607 1.1503493803760083 1.5341205443525465 0.55255681818181823 0.59506172839506177 0.62336448598130845 0.65333333333333332 0.67713310580204777 0.740590405904059 0.81499999999999995 0.82511210762331844 0.85986394557823131 0.86814814814814811 0.91111111111111109 0.91627906976744189 0.9187134502923977 0.92989130434782608 0.93312499999999998

Normal Score

Usage (kilowatt-hours per square foot)

1000 1500 2000 2500 3000 3500 3999.99 20 26.666666666666668 13.333333333333334 13.333333333333334 20 6.666666666666667

Size (square feet)

Percent