Question

In: Statistics and Probability

Below is a data set containing information on applicants applying for automobile insurance with an insurance...

Below is a data set containing information on applicants applying for automobile insurance with an insurance company. Here is a description of each variable:

Conduct a test to see if the population average annual Claims Paid is higher for people who are Not Married thant it is for people who are Married. Use alpha = 0.05. State hypotheses. Explain your results. Assume that the population standard deviations are not equal.

App. No. Marital Status Education Annual Salary Credit Score Age Claims Paid
111 Married Graduate $57,497 824 58 $4,247
112 Not Married Graduate $52,418 701 39 $2,862
113 Not Married College $44,638 619 49 $5,466
114 Not Married High School $42,371 664 56 $3,971
115 Not Married High School $30,223 551 22 $4,539
116 Married College $51,969 768 46 $4,980
117 Married College $51,682 763 46 $5,274
118 Not Married College $53,657 797 58 $10,123
119 Married Graduate $50,297 671 33 $4,145
120 Not Married High School $22,975 349 19 $4,625
121 Not Married High School $40,837 711 43 $5,180
122 Not Married High School $28,822 527 24 $8,953
123 Not Married High School $34,002 568 20 $5,599
124 Not Married High School $34,167 641 21 $3,213
125 Not Married College $48,480 755 48 $4,859
126 Married College $36,426 512 24 $4,580
127 Not Married High School $24,768 440 21 $15,283
128 Married High School $43,367 726 35 $3,792
129 Not Married High School $37,695 570 53 $8,728
130 Married College $38,087 551 24 $3,168
131 Not Married College $37,149 532 52 $5,824
132 Not Married High School $38,059 641 22 $13,839
133 Not Married High School $41,545 645 54 $17,849
134 Married College $38,471 514 41 $4,990
135 Married High School $38,213 611 37 $9,609
136 Married College $40,689 598 26 $4,201
137 Married Graduate $47,336 626 25 $3,970
138 Not Married College $40,150 639 24 $4,041
139 Married High School $36,112 598 23 $4,951
140 Married Graduate $48,299 596 54 $5,516
141 Married College $46,125 671 40 $5,180
142 Married High School $39,119 628 40 $5,112
143 Not Married High School $39,084 676 46 $4,508
144 Not Married High School $33,911 628 20 $4,637
145 Not Married High School $48,417 797 53 $12,654
146 Married High School $43,448 710 41 $3,351
147 Not Married Graduate $47,798 694 26 $11,624
148 Not Married Graduate $51,510 738 46 $10,998
149 Not Married College $36,800 510 26 $4,129
150 Not Married High School $34,125 558 53 $4,771
151 Married College $50,500 757 45 $6,042
152 Not Married College $39,523 619 27 $7,294
153 Not Married High School $22,231 333 17 $6,486
154 Married Graduate $43,892 526 41 $2,805
155 Married High School $33,406 538 26 $5,316
156 Married College $50,224 739 43 $5,951
157 Married Graduate $57,384 777 48 $7,009
158 Not Married Graduate $40,322 544 31 $4,856
159 Not Married High School $28,477 520 22 $9,060
160 Married Graduate $58,340 790 50 $4,161
161 Not Married High School $21,009 317 43 $5,295
162 Married College $52,491 766 52 $4,365
163 Not Married College $40,004 622 39 $9,998
164 Not Married Graduate $32,482 368 32 $7,556
165 Not Married High School $31,212 571 24 $5,274
166 Married College $45,131 646 43 $4,918
167 Married College $43,538 662 52 $4,725
168 Not Married College $49,627 736 44 $3,974
169 Not Married High School $38,093 638 24 $5,597
170 Not Married Graduate $44,583 614 30 $5,490
171 Not Married College $46,181 661 43 $9,882
172 Not Married Graduate $47,095 661 36 $11,059
173 Not Married High School $27,879 501 20 $4,563
174 Married College $36,408 531 48 $4,841
175 Married Graduate $54,540 723 46 $4,950
176 Married Graduate $55,175 733 50 $4,899
177 Not Married College $26,034 343 37 $5,494
178 Married College $42,516 624 31 $3,393
179 Married College $49,063 738 38 $4,116
180 Married College $48,755 709 44 $9,381
181 Not Married College $40,594 520 56 $5,333
182 Not Married High School $34,083 573 23 $5,441
183 Married College $39,330 625 27 $4,509
184 Not Married College $41,266 583 32 $4,950
185 Not Married College $39,517 538 37 $5,593
186 Not Married Graduate $46,392 555 53 $11,056
187 Married High School $36,613 610 26 $5,933
188 Married College $44,291 651 32 $5,295
189 Not Married College $43,511 639 29 $4,375
190 Married College $46,389 671 46 $3,729
191 Married College $40,624 565 36 $9,326
192 Married High School $39,490 713 35 $4,399
193 Married College $48,703 779 47 $5,628
194 Married High School $33,310 580 35 $4,998
195 Not Married High School $33,913 565 20 $5,597
196 Not Married High School $31,408 519 21 $4,597
197 Not Married Graduate $45,072 640 22 $4,951
198 Not Married College $51,427 819 51 $4,980
199 Married College $44,637 659 30 $6,433
200 Married College $49,429 744 36 $5,199

Solutions

Expert Solution



Related Solutions

An ANOVA procedure was performed on a data-set containing information on land values in five neighboring...
An ANOVA procedure was performed on a data-set containing information on land values in five neighboring counties. The analysis indicated that at least one pair of land values was significantly different from each other. The LSD was found to be $185/acre at the 5% confidence level. Data for the five counties are listed below. Which county land values are significantly different from each other? Be sure to use terminology such as significantly higher or significantly lower in your descriptions.   County...
Please perform hypothesis test (F-test) Below is the output corresponding to a data set containing one...
Please perform hypothesis test (F-test) Below is the output corresponding to a data set containing one response variable, Y, and 4 predictor variables, var1, var2, var3, and var4. The var1, var2, and var3 predictor variables are quantitative and var4 is qualitative with levels A, B, and C. Only use var1 and var2 Obs Y var1 var2 var3 var4 1 33.2 3.5 9 6.1 A 2 40.3 5.3 20 6.4 A 3 38.7 5.1 18 7.4 A 4 36.8 5.6 27...
The data set 2017NBADraft.txt is a comma delimited file containing data on the players selected in...
The data set 2017NBADraft.txt is a comma delimited file containing data on the players selected in the 2017 NBA draft. Assume this data set is a representative sample of all players in the NBA. Correctly import the data set into R. c) In R, perform a hypothesis test to determine if the mean weights are different for the first round selections and second round selections. To do this, create a new variable so that the first 30 players all have...
You are given a data set containing the height, weight, age, and blood pressure of a...
You are given a data set containing the height, weight, age, and blood pressure of a representative sample of people from a major metropolitan area. Comment on the suitability of using a statistically-based versus a cluster-based outlier detection scheme to identify people with anomalous characteristics for this data set.   
Why must insurance companies screen applicants so carefully?
Why must insurance companies screen applicants so carefully?
Question 3 0 / 3 pts Suppose you are working with the automobile data set and...
Question 3 0 / 3 pts Suppose you are working with the automobile data set and got the following printout. Assume that you already tested the quadratic terms and dropped them out of the model. The following printout was created. Least Squares Linear Regression of Price Predictor Variables    Coefficient    Std Error    T    P VIF Constant    20339.7 1039.20 19.57    0.0000 0.0 Mileage -0.06642 0.02264    -2.93    0.0052    1.8 Model 1255.69 1454.48    0.86...
For the data below: Year Automobile Sales Year Automobile Sales 1990 116 1997 119 1991 105...
For the data below: Year Automobile Sales Year Automobile Sales 1990 116 1997 119 1991 105 1998 34 1992 29 1999 34 1993 59 2000 48 1994 108 2001 53 1995 94 2002 65 1996 27 2003 111 (a)           Determine the least squares regression line using Excel. (b)           Determine the predicted value for 2004. (c)           Determine the 3 year moving average. (d)           Determine the MSE for the trend line (in a) and the 3 year moving average (in c.) Which forecasting method is better?...
The Carseat is a data set containing sales of child car seats at 400 different stores....
The Carseat is a data set containing sales of child car seats at 400 different stores. Your task is to develop a regression model to predict sales and use this data to estimate your model. Description of variables: Sales: Unit sales (in thousands) at each location CompPrice: Price charged by competitor at each location Income: Community income level (in thousands of dollars) Advertising: Local advertising budget for company at each location (in thousands of dollars) Population: Population size in region...
The Carseat is a data set containing sales of child car seats at 400 different stores....
The Carseat is a data set containing sales of child car seats at 400 different stores. Your task is to develop a regression model to predict sales and use this data to estimate your model. Description of variables: Sales: Unit sales (in thousands) at each location CompPrice: Price charged by competitor at each location Income: Community income level (in thousands of dollars) Advertising: Local advertising budget for company at each location (in thousands of dollars) Population: Population size in region...
Below is a growth data of a microorganism cultured in a flask containing a liquid nutrient...
Below is a growth data of a microorganism cultured in a flask containing a liquid nutrient medium. Samples were taken hourly and number of cells counted using a counting chamber. Data is provided in cells per mL. Draw a growth curve in Excel and use it to calculate generation time. The answer must be provided in minutes. Do not discard your growth curve as you will need to upload it after submitting your answer to this question. Make sure you...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT