statistics help, write a speech

profileYvonne Chen
doc1.docx

Question 1

question 2

2500+0.04*1000000

y=age at death

y = -0.1567x + 96.894

137.0 162.0 270.0 210.0 233.0 90.0 252.0 156.0 127.0 194.0 205.0 266.0 216.0 167.0 230.0 171.0 155.0 128.0 274.0 198.0 268.0 206.0 204.0 177.0 337.0 222.0 180.0 174.0 274.0 211.0 149.0 224.0 190.0 158.0 161.0 126.0 159.0 201.0 134.0 129.0 193.0 95.0 156.0 220.0 211.0 206.0 153.0 247.0 212.0 189.0 160.0 245.0 49.0 203.0 159.0 210.0 198.0 181.0 127.0 186.0 186.0 183.0 233.0 163.0 263.0 195.0 218.0 232.0 184.0 253.0 158.0 60.0 191.0 210.0 118.0 174.0 233.0 285.0 290.0 217.0 183.0 217.0 250.0 80.0 141.0 246.0 136.0 162.0 219.0 135.0 261.0 221.0 182.0 233.0 206.0 191.0 220.0 252.0 213.0 167.0 63.0 85.0 59.0 73.0 79.0 91.0 47.0 72.0 97.0 49.0 51.0 59.0 51.0 62. 0 78.0 72.0 93.0 91.0 72.0 63.0 35.0 76.0 74.0 78.0 58.0 69.0 71.0 67.0 47.0 70.0 83.0 47.0 52.0 58.0 56.0 77.0 59.0 77.0 71.0 90.0 60.0 104.0 60.0 67.0 70.0 58.0 61.0 72.0 75.0 54.0 86.0 57.0 75.0 81.0 79.0 83.0 63.0 60.0 63.0 55.0 68.0 72.0 43.0 54.0 67.0 66.0 68.0 50.0 55.0 73.0 90.0 79.0 64.0 77.0 70.0 53.0 49.0 56.0 45.0 47.0 73.0 53.0 41.0 93.0 71.0 41.0 85.0 72.0 45.0 86.0 64.0 68.0 88.0 41.0 51.0 72.0 80.0 53.0 76.0 64.0

��������������

Regression Statistics �,$+"'$ �� �� ����� ���(,�) ���������� ��#,*+ �����(,�) ��� ��� �� �+�%��)���))&) ���� �� �� ��* )-�+"&%* ���

����� df SS MS F Significance F

� !) **"&% � ��������� ������ ������� �� ������ � *"�,�$ � ������ ���� �� �� �&+�$ �� ����

Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% �%+ )� '+ �� ����� ��� �� �� ������� � ����� ������� ���� �� ��� ������� �� �� �� ��� ����)"��$ �� ���� � ����� ����� � � ��� �� ��� ��������� ������� �� �� ��������� �� ����� �� ���

Sheet1

SUMMARY OUTPUT
Regression Statistics
Multiple R 0.5517004948
R Square 0.304373436
Adjusted R Square 0.2972752057
Standard Error 12.093396231
Observations 100
ANOVA
df SS MS F Significance F
Regression 1 6271.2372249001 6271.2372249001 42.8801863903 0.0000000027
Residual 98 14332.5227750999 146.250232399
Total 99 20603.76
Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
Intercept 96.8937474043 4.76983942 20.3138384486 6.64375691466767E-37 87.428156312 106.3593384966 87.428156312 106.3593384966
X Variable 1 -0.1566615545 0.0239240168 -6.5482964495 0.0000000027 -0.2041379873 -0.1091851217 -0.2041379873 -0.1091851217