Click "Enable Editing" first. If the "Enable Content" warning shows up, click "Enable Content". A pop-up window will now appear. Please enter your First Name, Last Name ntent". Name, Last Name and ID as shown in PeopleSoft. Click "Enable Editing" first. If the "Enable Content" warning shows up, click "Enable Content". A pop-up window will now appear. Please enter your First Name, Last Name ntent". Name, Last Name and ID as shown in PeopleSoft. First Name Last Name Cougernet ID Peoplesoft ID Section # Ali Jafri atjafri 1347226 17516 LEGEND Answer must be typed to either 2 use the tables provided in STAT 3 TISETC TINSETC Answer must be typed to four de Answer must be chosen from dro Answer must be derived using ce There is significant evidence to c There is not significant evidence Note: Answer Questions 1-3 by Using the TIIMPORTANT: Make sure you carry all decimals until you reach your According to statistics reported on CNBC, a surprising number of motor vehicles are not covered report, showed 47 of 211 vehicles were not covered by insurance. (See exercise 36 on page 369 o Question 1A Can you prove the proportion of vehicles not covered by insurance is different from 16% at = Step 1: Step 2: Step 3: H0: p = Ha: p z crit = - Fill in row 34 if the hypothesis is one tailed. Reject H0 if z stat < Fill in row 38 if the hypothesis is two tailed. The smaller number mu Reject H0 if Step 4: z stat z stat < = 2.486 Step 5: Reject H0 Step 6: TISETC p Step 7: Fill in row 48 if the Z table is appropriate. P-value = 0.0126 Fill in row 52 if the t table is appropriate. The lower boundary must g 0.0126 Question 1B = P-value Construct a 99% confidence interval for the true proportion of vehicles not covered by insuran Lower Endpoint 0.149 Upper Endpoint 0.297 The following 86% C.I. for was obtained from a sample of 25 observations (the population varia Question 2A What is xx? 92.8129 Question 2B What is ? 5027.997 According to American Consumer Credit Counseling statistics, credit card debt is the third largest were collected from a random sample of 12 credit cards. (See the example on page 354 of your t Credit Card Balance $ 10,099.00 $ $ $ $ $ $ $ $ $ $ $ Question 3A 18,531.00 14,346.00 12,671.00 3,492.00 6,115.00 13,916.00 11,817.00 15,963.00 5,204.00 4,247.00 14,652.00 Can you reject the hypothesis that the mean credit card balance is no less than $6630 at =0. Step 1: Step 2: Step 3: H0: Ha: p = z stat = + Fill in row 106 if the hypothesis is one tailed. Reject H0 if t stat > Fill in row 110 if the hypothesis is two tailed. The smaller number m Reject H0 if t stat < 3.4966 Step 4: t crit = Step 5: Reject H0 Step 6: TISETC p Step 7: = Fill in row 120 if the Z table is appropriate. P-value = 0.0015 Fill in row 124 if the t table is appropriate. The lower boundary must 0.0065 Question 3B P-value Construct a 98% confidence interval for the population mean credit card balance. Lower Endpoint Question 3C > 6976.58 Upper Endpoint 14865.59 What would the P-value be if this were a two tail hypothesis test? (Mathematically manipulate Fill in row 136 if the Z table is appropriate. P-value = 0.003 Fill in row 140 if the t table is appropriate. The lower boundary must go on the left and the upp 0.013 > P-value < Note: Answer Questions 4 and 5 by Using th A random sample of American motorists were asked if they text while driving. Use the data in th to answer the following questions. Each orange numerical answer cell below MUST reference Ex Question 4A Does the data suggest that more than 43% of American motorists text while driving at alpha=0 Step 1: Step 2: H0: p = Ha: p > z crit = + Step 3: Fill in row 167 if the hypothesis is one tailed. Reject H0 if z stat > Fill in row 171 if the hypothesis is two tailed. The smaller number m Reject H0 if Question 4B z stat < 3.7108 Step 4: z stat = Step 5: Reject H0 Step 6: TISETC p = Step 7: P-value = ### Construct a 84% confidence interval for the proportion of all American motorists who text whi Lower Endpoint 0.4763 Upper Endpoint 0.5337 A study commissioned by the City of Houston in July 2013 asked a random sample of unemploye unemployed. Use the data in the Unemployed sheet in this workbook to generate excel output t answer cell below MUST reference Excel output cells in the Unemployed sheet. Question 5A Can you conclude that the average duration of unemployment in Houston is less than the natio Step 1: Step 2: Step 3: H0: Ha: p < t crit = + Fill in row 204 if the hypothesis is one tailed. Reject H0 if t stat > Fill in row 208 if the hypothesis is two tailed. The smaller number m Reject H0 if Question 5B < -2.2329 Step 4: t stat = Step 5: Reject H0 Step 6: TINSETC p = Step 7: P-value = ### Construct a 96% confidence interval for the true average duration of unemployment in Housto Lower Endpoint Question 5C t stat 22.2205 Upper Endpoint 29.6017 Using descriptive statistics off the Excel output generated for parts A and B, construct a 80% co during July 2013. Lower Endpoint 23.5285 Upper Endpoint 28.2937 must be typed to either 2 or 3 decimals depending on whether the Z or t table is appropriate. Please tables provided in STAT 3331 (not the tables in the textbook). must be typed to four decimals must be chosen from drop down menu must be derived using cell references significant evidence to conclude not significant evidence to conclude by Using the TI-30XA Calculator til you reach your answer, then round to four decimals. hicles are not covered by insurance. Simple results, consistent with the CNBC rcise 36 on page 369 of your textbook for a similar problem.) different from 16% at =0.05? 0.16 0.16 1.96 -1.96 The smaller number must be typed first. -1.96 or z stat > 1.96 0.16 he lower boundary must go on the left and the upper boundary on the right. = 0.0126 es not covered by insurance. (the population variance is known): (-268.7928, 83.1670) ebt is the third largest source of household indebtedness. The following data on page 354 of your textbook for a similar problem.) o less than $6630 at =0.005? 6630 0.0066 2.96 3.1058 d. The smaller number must be typed first. -3.4966 or t stat > 0.0065 The lower boundary must go on the left and the upper boundary on the right. 3.4966 < 0.0065 0.013 ard balance. athematically manipulate the P-value from part A to get your answer) go on the left and the upper boundary on the right. 0.013 and 5 by Using the Excel Output ng. Use the data in the Texting sheet in this workbook to generate excel output w MUST reference Excel output cells in the Texting sheet. t while driving at alpha=0.01? 0.43 0.43 2.3263 2.3263 d. The smaller number must be typed first. -2.5758 or z stat > 2.5758 0.01 n motorists who text while driving. sample of unemployed Houstonians how many weeks they have been enerate excel output to answer the following questions. Each orange numerical eet. ston is less than the national average of 30 weeks during July 2013 at alpha=0.025? 30 30 1.6802 1.6802 d. The smaller number must be typed first. -2.0154 or t stat > 2.0154 0.3305 unemployment in Houston during July 2013. and B, construct a 80% confidence interval for the true average duration of unemployment in Houston Possible Answers 65 Pts Output 30 Pts Free 5 Pts Total 95 Pts Your Score 1 Pt 1 Pt 1 Pt 0 Pts 1 Pt 0 Pts 2 Pts 2 Pts 18 Pts 0 Pts 5 Pts 23 Pts 1 Pt 1 Pt 1 Pt 1 Pt 3 Pts 0 Pts 3 Pts 0 Pts 3 Pts 0 Pts 4 Pts 0 Pts 1 Pt 0 Pts 1 Pt 0 Pts 1 Pt 0 Pts 2 Pts 0 Pts 1 Pt 0 Pts 1 Pt 0 Pts 3 Pts 0 Pts 3 Pts 0 Pts 3 Pts 0 Pts 1 Pt 0 Pts 1 Pt 1 Pt 1 Pt 0 Pts 2 Pts 2 Pts 1 Pt 1 Pt 1 Pt 0 Pts 3 Pts 3 Pts 3 Pts 3 Pts 1 Pt 0 Pts 1 Pt 0 Pts 1 Pt 0 Pts 2 Pts 2 Pts 1 Pt 1 Pt 1 Pt 0 Pts 3 Pts 0 Pts 3 Pts 0 Pts 3 Pts 0 Pts First Name Last Name Cougernet ID Peoplesoft ID Section # Ali Jafri atjafri 1347226 17516 LEGEND Answer must be typed to either 2 use the tables provided in STAT 3 TISETC TINSETC Answer must be typed to four de Answer must be chosen from dro Answer must be derived using ce There is significant evidence to c There is not significant evidence Note: Answer Questions 1-3 by Using the TIIMPORTANT: Make sure you carry all decimals until you reach your According to statistics reported on CNBC, a surprising number of motor vehicles are not covered report, showed 47 of 211 vehicles were not covered by insurance. (See exercise 36 on page 369 o Question 1A Can you prove the proportion of vehicles not covered by insurance is different from 16% at = Step 1: Step 2: Step 3: H0: p = Ha: p z crit = Fill in row 34 if the hypothesis is one tailed. Reject H0 if Fill in row 38 if the hypothesis is two tailed. The smaller number mu Reject H0 if Step 4: z stat z stat < = 2.49 Step 5: Reject H0 Step 6: TISETC p Step 7: Fill in row 48 if the Z table is appropriate. P-value = 0.0128 Fill in row 52 if the t table is appropriate. The lower boundary must g P-value Question 1B Construct a 99% confidence interval for the true proportion of vehicles not covered by insuran Lower Endpoint 0.149 Upper Endpoint 0.2965 The following 86% C.I. for was obtained from a sample of 25 observations (the population varia Question 2A What is xx? -92.8129 Question 2B What is ? 594.5267 According to American Consumer Credit Counseling statistics, credit card debt is the third largest were collected from a random sample of 12 credit cards. (See the example on page 354 of your t Credit Card Balance $ 10,099.00 $ $ $ $ $ $ $ $ $ $ $ Question 3A 18,531.00 14,346.00 12,671.00 3,492.00 6,115.00 13,916.00 11,817.00 15,963.00 5,204.00 4,247.00 14,652.00 Can you reject the hypothesis that the mean credit card balance is no less than $6630 at =0. Step 1: Step 2: Step 3: H0: Ha: < t crit = - Fill in row 106 if the hypothesis is one tailed. Reject H0 if t stat < Fill in row 110 if the hypothesis is two tailed. The smaller number m Reject H0 if Step 4: t stat = Step 5: Fail to Reject H0 Step 6: TINSETC Step 7: 2.957 < Fill in row 120 if the Z table is appropriate. P-value = Fill in row 124 if the t table is appropriate. The lower boundary must 0.99 Question 3B P-value Construct a 98% confidence interval for the population mean credit card balance. Lower Endpoint Question 3C < 6976.5772 Upper Endpoint 14865.5894 What would the P-value be if this were a two tail hypothesis test? (Mathematically manipulate Fill in row 136 if the Z table is appropriate. P-value = Fill in row 140 if the t table is appropriate. The lower boundary must go on the left and the upp 0.01 < P-value < Note: Answer Questions 4 and 5 by Using th A random sample of American motorists were asked if they text while driving. Use the data in th to answer the following questions. Each orange numerical answer cell below MUST reference Ex Question 4A Does the data suggest that more than 43% of American motorists text while driving at alpha=0 Step 1: Step 2: H0: p Ha: p > z crit = + Step 3: Fill in row 167 if the hypothesis is one tailed. Reject H0 if z stat > Fill in row 171 if the hypothesis is two tailed. The smaller number m Reject H0 if Question 4B Step 4: z stat = 3.7108 Step 5: Reject H0 Step 6: TISETC p > Step 7: P-value = 0.0001 Construct a 84% confidence interval for the proportion of all American motorists who text whi Lower Endpoint 0.4763 Upper Endpoint 0.5337 A study commissioned by the City of Houston in July 2013 asked a random sample of unemploye unemployed. Use the data in the Unemployed sheet in this workbook to generate excel output t answer cell below MUST reference Excel output cells in the Unemployed sheet. Question 5A Can you conclude that the average duration of unemployment in Houston is less than the natio Step 1: Step 2: Step 3: H0: Ha: < t crit = - Fill in row 204 if the hypothesis is one tailed. Reject H0 if t stat < Fill in row 208 if the hypothesis is two tailed. The smaller number m Reject H0 if Question 5B Step 4: t stat = Step 5: Reject H0 Step 6: TISETC < Step 7: P-value = 0.0153 Construct a 96% confidence interval for the true average duration of unemployment in Housto Lower Endpoint Question 5C -2.2329 22.0355 Upper Endpoint 29.7868 Using descriptive statistics off the Excel output generated for parts A and B, construct a 80% co during July 2013. Lower Endpoint 23.5287 Upper Endpoint 28.2935 must be typed to either 2 or 3 decimals depending on whether the Z or t table is appropriate. Please tables provided in STAT 3331 (not the tables in the textbook). must be typed to four decimals must be chosen from drop down menu must be derived using cell references significant evidence to conclude not significant evidence to conclude by Using the TI-30XA Calculator til you reach your answer, then round to four decimals. hicles are not covered by insurance. Simple results, consistent with the CNBC rcise 36 on page 369 of your textbook for a similar problem.) different from 16% at =0.05? 0.16 0.16 1.96 The smaller number must be typed first. -1.96 or z stat > 1.96 0.16 he lower boundary must go on the left and the upper boundary on the right. es not covered by insurance. (the population variance is known): (-268.7928, 83.1670) ebt is the third largest source of household indebtedness. The following data on page 354 of your textbook for a similar problem.) o less than $6630 at =0.005? 6630 6630 3.106 -3.106 d. The smaller number must be typed first. or 6630 The lower boundary must go on the left and the upper boundary on the right. < 0.995 ard balance. athematically manipulate the P-value from part A to get your answer) go on the left and the upper boundary on the right. 0.02 and 5 by Using the Excel Output ng. Use the data in the Texting sheet in this workbook to generate excel output w MUST reference Excel output cells in the Texting sheet. t while driving at alpha=0.01? 0.43 0.43 2.33 2.33 d. The smaller number must be typed first. or 0.43 n motorists who text while driving. sample of unemployed Houstonians how many weeks they have been enerate excel output to answer the following questions. Each orange numerical eet. ston is less than the national average of 30 weeks during July 2013 at alpha=0.025? 30 30 2.015 -2.015 d. The smaller number must be typed first. or 30 unemployment in Houston during July 2013. and B, construct a 80% confidence interval for the true average duration of unemployment in Houston HOMEWORK ANSWER COMMENTS: 1 Type of problem: Inference for p, n large 2 Remember, the left and right endpoints are the same distance from xx 3 Type of problem: Inference for , unknown 4 Type of problem: Inference for p, n large 5 Type of problem: Inference for , unknown Texting? No No No Yes No No No Yes Yes Yes Yes No No No Yes Yes Yes Yes No Yes No No No No No Yes Yes Yes Yes No No No Yes No Yes Yes No No Yes No No No No Yes Yes No No The Excel output for this data must start in D11. (That m MUST follow the templates in the CHAP8&9 sheets in th Texting? Sum - Texting? No Yes Total Result P` #DIV/0! Yes No Yes Yes Yes Yes Yes No No No No Yes Yes No Yes No No No Yes Yes No Yes No Yes Yes No No Yes Yes Yes No Yes Yes No Yes No No Yes No Yes Yes No Yes Yes Yes No Yes Yes Yes No No No Yes No No No Yes Yes No No Yes No Yes No No No No No Yes Yes Yes No Yes Yes Yes Yes Yes Yes No Yes Yes Yes No No No No No No No No Yes Yes Yes Yes Yes No Yes No Yes No No Yes Yes Yes No No No No No No No No No No No Yes Yes No No No No Yes No No No Yes Yes No Yes No No No Yes No Yes No Yes Yes No No No Yes Yes Yes Yes Yes No No No Yes Yes Yes Yes No Yes No Yes Yes Yes No No No No Yes Yes Yes No No No Yes Yes No Yes No Yes No Yes Yes No Yes Yes Yes No Yes Yes No Yes No Yes Yes Yes Yes Yes No Yes No No No No No No No No Yes Yes Yes Yes No Yes No Yes Yes No No Yes Yes Yes Yes No No Yes Yes Yes Yes Yes Yes Yes No No Yes Yes No No Yes Yes No Yes No No No Yes No No Yes No No Yes No No Yes Yes Yes Yes No Yes No Yes Yes No Yes No Yes No Yes No Yes Yes No Yes Yes Yes No No No Yes No Yes Yes Yes Yes No No No No No No Yes Yes No No Yes Yes Yes No Yes No Yes No Yes Yes Yes No Yes Yes No No No Yes No Yes Yes Yes Yes No No No No No No No Yes Yes Yes No No No No Yes No Yes Yes No Yes Yes Yes Yes No No Yes Yes Yes Yes Yes Yes Yes No No Yes No Yes No No Yes No No Yes No No Yes No No No No No No No Yes No No Yes Yes No Yes Yes No Yes No No No Yes Yes Yes No Yes Yes Yes No No Yes No No Yes No No No No No Yes Yes No Yes Yes Yes Yes Yes No Yes No Yes No No No Yes No Yes No No Yes Yes Yes No No No Yes Yes No Yes Yes Yes No Yes No Yes Yes Yes Yes No Yes Yes No Yes Yes Yes No No Yes Yes Yes No Yes Yes No No Yes Yes Yes No Yes No Yes Yes No No Yes No Yes No Yes Yes No Yes Yes Yes No Yes Yes No Yes Yes No No No Yes Yes Yes No Yes Yes Yes No No No Yes Yes Yes Yes Yes Yes Yes No Yes No Yes No No Yes Yes Yes No Yes Yes Yes Yes No No No Yes Yes Yes No No No Yes No Yes No No No Yes No No No No No Yes No Yes Yes No No No No No No No No Yes Yes No No No No No in D11. (That means E11 should have the label for the dataset.) You &9 sheets in the Excel Templates spreadsheet to receive full credit. Solution Response of Interest Texting? Yes Sample Size Count for Response Sample Proportion 600 303 0.5050 Confidence Interval Confidence Coefficient 0.84 Lower Limit 0.4763 Upper Limit 0.5337 Hypothesis Test Hypothesized Value z Test Statistic Pts Of -3 -4 0.43 3.7108 -4 P-value (LST) P-value (RST) P-value (2ST) -4 0.0002 Deductions Incorrect Answers Points Lost -15.0 -15.0 Formatting 4 Decimal Places Bold Font Correct borders Column Width 0 0 0 0 Label Correct Points Lost 0 -3.0 Total Score Max Possible Total Points Lost: Final Score: 15.0 -18.0 0.0 ou it. Weeks Unemployed 17 37 45 20 40 14 The Excel output for this data must start in D11. (T MUST follow the templates in the CHAP8&9 sheets 12.2842 25 10 43 17 Weeks Unemployed 33 9 12 45 44 17 39 40 18 33 20 23 35 43 10 45 14 19 33 8 16 14 15 18 20 9 10 24 45 33 38 36 24 31 25 Mean Standard Error Median Mode Standard Deviation Sample Variance Kurtosis Skewness Range Minimum Maximum Sum Count Confidence Level(95.0 25.9111 1.83122 24 45 12.2842 150.901 -1.39183 0.2102 37 8 45 1166 45 3.69058 must start in D11. (That means E11 should have the label for the dataset.) You he CHAP8&9 sheets in the Excel Templates spreadsheet to receive full credit. Solution Weeks Unemployed Sample Size 45 Sample Mean Sample Standard Deviation 25.9111 12.2842 Confidence Interval Confidence Coefficient Lower Limit Upper Limit 0.96 22.0355 29.7868 Pts Of -3 -4 Hypothesis Test Hypothesized Value t Test Statistic P-value (LST) 30 -2.2329 -4 P-value (RST) 0.9847 -4 P-value (2ST) el for the dataset.) You t to receive full credit. tion Deductions Incorrect Answers Points Lost -15.0 -15.0 Formatting 4 Decimal Places Bold Font Correct borders Column Width 0 0 0 0 Label Correct Points Lost -3.0 0 Total Score Max Possible Total Points Lost: Final Score: 15.0 -18.0 0.0 Click "Enable Editing" first. If the "Enable Content" warning shows up, click "Enable Content". A pop-up window will now appear. Please enter your First Name, Last Name ntent". Name, Last Name and ID as shown in PeopleSoft. First Name Last Name Cougernet ID Peoplesoft ID Section # Ali Jafri atjafri 1347226 17516 LEGEND Answer must be typed to either 2 use the tables provided in STAT 3 TISETC TINSETC Answer must be typed to four de Answer must be chosen from dro Answer must be derived using ce There is significant evidence to c There is not significant evidence Note: Answer Questions 1-3 by Using the TIIMPORTANT: Make sure you carry all decimals until you reach your According to statistics reported on CNBC, a surprising number of motor vehicles are not covered report, showed 47 of 211 vehicles were not covered by insurance. (See exercise 36 on page 369 o Question 1A Can you prove the proportion of vehicles not covered by insurance is different from 16% at = Step 1: Step 2: Step 3: H0: p = Ha: p z crit = - Fill in row 34 if the hypothesis is one tailed. Reject H0 if z stat < Fill in row 38 if the hypothesis is two tailed. The smaller number mu Reject H0 if Step 4: z stat z stat < = 2.486 Step 5: Reject H0 Step 6: TISETC p Step 7: Fill in row 48 if the Z table is appropriate. P-value = 0.0126 Fill in row 52 if the t table is appropriate. The lower boundary must g 0.0126 Question 1B = P-value Construct a 99% confidence interval for the true proportion of vehicles not covered by insuran Lower Endpoint 0.149 Upper Endpoint 0.297 The following 86% C.I. for was obtained from a sample of 25 observations (the population varia Question 2A What is xx? 92.8129 Question 2B What is ? 5027.997 According to American Consumer Credit Counseling statistics, credit card debt is the third largest were collected from a random sample of 12 credit cards. (See the example on page 354 of your t Credit Card Balance $ 10,099.00 $ $ $ $ $ $ $ $ $ $ $ Question 3A 18,531.00 14,346.00 12,671.00 3,492.00 6,115.00 13,916.00 11,817.00 15,963.00 5,204.00 4,247.00 14,652.00 Can you reject the hypothesis that the mean credit card balance is no less than $6630 at =0. Step 1: Step 2: Step 3: H0: Ha: p = z stat = + Fill in row 106 if the hypothesis is one tailed. Reject H0 if t stat > Fill in row 110 if the hypothesis is two tailed. The smaller number m Reject H0 if t stat < 3.4966 Step 4: t crit = Step 5: Reject H0 Step 6: TISETC p Step 7: = Fill in row 120 if the Z table is appropriate. P-value = 0.0015 Fill in row 124 if the t table is appropriate. The lower boundary must 0.0065 Question 3B P-value Construct a 98% confidence interval for the population mean credit card balance. Lower Endpoint Question 3C > 6976.58 Upper Endpoint 14865.59 What would the P-value be if this were a two tail hypothesis test? (Mathematically manipulate Fill in row 136 if the Z table is appropriate. P-value = 0.003 Fill in row 140 if the t table is appropriate. The lower boundary must go on the left and the upp 0.013 > P-value < Note: Answer Questions 4 and 5 by Using th A random sample of American motorists were asked if they text while driving. Use the data in th to answer the following questions. Each orange numerical answer cell below MUST reference Ex Question 4A Does the data suggest that more than 43% of American motorists text while driving at alpha=0 Step 1: Step 2: H0: p = Ha: p > z crit = + Step 3: Fill in row 167 if the hypothesis is one tailed. Reject H0 if z stat > Fill in row 171 if the hypothesis is two tailed. The smaller number m Reject H0 if Question 4B z stat < 3.7108 Step 4: z stat = Step 5: Reject H0 Step 6: TISETC p = Step 7: P-value = ### Construct a 84% confidence interval for the proportion of all American motorists who text whi Lower Endpoint 0.4763 Upper Endpoint 0.5337 A study commissioned by the City of Houston in July 2013 asked a random sample of unemploye unemployed. Use the data in the Unemployed sheet in this workbook to generate excel output t answer cell below MUST reference Excel output cells in the Unemployed sheet. Question 5A Can you conclude that the average duration of unemployment in Houston is less than the natio Step 1: Step 2: Step 3: H0: Ha: p < t crit = + Fill in row 204 if the hypothesis is one tailed. Reject H0 if t stat > Fill in row 208 if the hypothesis is two tailed. The smaller number m Reject H0 if Question 5B < -2.2329 Step 4: t stat = Step 5: Reject H0 Step 6: TINSETC p = Step 7: P-value = ### Construct a 96% confidence interval for the true average duration of unemployment in Housto Lower Endpoint Question 5C t stat 22.2205 Upper Endpoint 29.6017 Using descriptive statistics off the Excel output generated for parts A and B, construct a 80% co during July 2013. Lower Endpoint 23.5285 Upper Endpoint 28.2937 must be typed to either 2 or 3 decimals depending on whether the Z or t table is appropriate. Please tables provided in STAT 3331 (not the tables in the textbook). must be typed to four decimals must be chosen from drop down menu must be derived using cell references significant evidence to conclude not significant evidence to conclude by Using the TI-30XA Calculator til you reach your answer, then round to four decimals. hicles are not covered by insurance. Simple results, consistent with the CNBC rcise 36 on page 369 of your textbook for a similar problem.) different from 16% at =0.05? 0.16 0.16 1.96 -1.96 The smaller number must be typed first. -1.96 or z stat > 1.96 0.16 he lower boundary must go on the left and the upper boundary on the right. = 0.0126 es not covered by insurance. (the population variance is known): (-268.7928, 83.1670) ebt is the third largest source of household indebtedness. The following data on page 354 of your textbook for a similar problem.) o less than $6630 at =0.005? 6630 0.0066 2.96 3.1058 d. The smaller number must be typed first. -3.4966 or t stat > 0.0065 The lower boundary must go on the left and the upper boundary on the right. 3.4966 < 0.0065 0.013 ard balance. athematically manipulate the P-value from part A to get your answer) go on the left and the upper boundary on the right. 0.013 and 5 by Using the Excel Output ng. Use the data in the Texting sheet in this workbook to generate excel output w MUST reference Excel output cells in the Texting sheet. t while driving at alpha=0.01? 0.43 0.43 2.3263 2.3263 d. The smaller number must be typed first. -2.5758 or z stat > 2.5758 0.01 n motorists who text while driving. sample of unemployed Houstonians how many weeks they have been enerate excel output to answer the following questions. Each orange numerical eet. ston is less than the national average of 30 weeks during July 2013 at alpha=0.025? 30 30 1.6802 1.6802 d. The smaller number must be typed first. -2.0154 or t stat > 2.0154 0.3305 unemployment in Houston during July 2013. and B, construct a 80% confidence interval for the true average duration of unemployment in Houston Possible Answers 65 Pts Output 30 Pts Free 5 Pts Total 95 Pts Your Score 1 Pt 1 Pt 1 Pt 0 Pts 1 Pt 0 Pts 2 Pts 2 Pts 18 Pts 0 Pts 5 Pts 23 Pts 1 Pt 1 Pt 1 Pt 1 Pt 3 Pts 0 Pts 3 Pts 0 Pts 3 Pts 0 Pts 4 Pts 0 Pts 1 Pt 0 Pts 1 Pt 0 Pts 1 Pt 0 Pts 2 Pts 0 Pts 1 Pt 0 Pts 1 Pt 0 Pts 3 Pts 0 Pts 3 Pts 0 Pts 3 Pts 0 Pts 1 Pt 0 Pts 1 Pt 1 Pt 1 Pt 0 Pts 2 Pts 2 Pts 1 Pt 1 Pt 1 Pt 0 Pts 3 Pts 3 Pts 3 Pts 3 Pts 1 Pt 0 Pts 1 Pt 0 Pts 1 Pt 0 Pts 2 Pts 2 Pts 1 Pt 1 Pt 1 Pt 0 Pts 3 Pts 0 Pts 3 Pts 0 Pts 3 Pts 0 Pts First Name Last Name Cougernet ID Peoplesoft ID Section # Ali Jafri atjafri 1347226 17516 LEGEND Answer must be typed to either 2 use the tables provided in STAT 3 TISETC TINSETC Answer must be typed to four de Answer must be chosen from dro Answer must be derived using ce There is significant evidence to c There is not significant evidence Note: Answer Questions 1-3 by Using the TIIMPORTANT: Make sure you carry all decimals until you reach your According to statistics reported on CNBC, a surprising number of motor vehicles are not covered report, showed 47 of 211 vehicles were not covered by insurance. (See exercise 36 on page 369 o Question 1A Can you prove the proportion of vehicles not covered by insurance is different from 16% at = Step 1: Step 2: Step 3: H0: p = Ha: p z crit = Fill in row 34 if the hypothesis is one tailed. Reject H0 if Fill in row 38 if the hypothesis is two tailed. The smaller number mu Reject H0 if Step 4: z stat z stat < = 2.49 Step 5: Reject H0 Step 6: TISETC p Step 7: Fill in row 48 if the Z table is appropriate. P-value = 0.0128 Fill in row 52 if the t table is appropriate. The lower boundary must g P-value Question 1B Construct a 99% confidence interval for the true proportion of vehicles not covered by insuran Lower Endpoint 0.149 Upper Endpoint 0.2965 The following 86% C.I. for was obtained from a sample of 25 observations (the population varia Question 2A What is xx? -92.8129 Question 2B What is ? 594.5267 According to American Consumer Credit Counseling statistics, credit card debt is the third largest were collected from a random sample of 12 credit cards. (See the example on page 354 of your t Credit Card Balance $ 10,099.00 $ $ $ $ $ $ $ $ $ $ $ Question 3A 18,531.00 14,346.00 12,671.00 3,492.00 6,115.00 13,916.00 11,817.00 15,963.00 5,204.00 4,247.00 14,652.00 Can you reject the hypothesis that the mean credit card balance is no less than $6630 at =0. Step 1: Step 2: Step 3: H0: Ha: < t crit = - Fill in row 106 if the hypothesis is one tailed. Reject H0 if t stat < Fill in row 110 if the hypothesis is two tailed. The smaller number m Reject H0 if Step 4: t stat = Step 5: Fail to Reject H0 Step 6: TINSETC Step 7: 2.957 < Fill in row 120 if the Z table is appropriate. P-value = Fill in row 124 if the t table is appropriate. The lower boundary must 0.99 Question 3B P-value Construct a 98% confidence interval for the population mean credit card balance. Lower Endpoint Question 3C < 6976.5772 Upper Endpoint 14865.5894 What would the P-value be if this were a two tail hypothesis test? (Mathematically manipulate Fill in row 136 if the Z table is appropriate. P-value = Fill in row 140 if the t table is appropriate. The lower boundary must go on the left and the upp 0.01 < P-value < Note: Answer Questions 4 and 5 by Using th A random sample of American motorists were asked if they text while driving. Use the data in th to answer the following questions. Each orange numerical answer cell below MUST reference Ex Question 4A Does the data suggest that more than 43% of American motorists text while driving at alpha=0 Step 1: Step 2: H0: p Ha: p > z crit = + Step 3: Fill in row 167 if the hypothesis is one tailed. Reject H0 if z stat > Fill in row 171 if the hypothesis is two tailed. The smaller number m Reject H0 if Question 4B Step 4: z stat = 3.7108 Step 5: Reject H0 Step 6: TISETC p > Step 7: P-value = 0.0001 Construct a 84% confidence interval for the proportion of all American motorists who text whi Lower Endpoint 0.4763 Upper Endpoint 0.5337 A study commissioned by the City of Houston in July 2013 asked a random sample of unemploye unemployed. Use the data in the Unemployed sheet in this workbook to generate excel output t answer cell below MUST reference Excel output cells in the Unemployed sheet. Question 5A Can you conclude that the average duration of unemployment in Houston is less than the natio Step 1: Step 2: Step 3: H0: Ha: < t crit = - Fill in row 204 if the hypothesis is one tailed. Reject H0 if t stat < Fill in row 208 if the hypothesis is two tailed. The smaller number m Reject H0 if Question 5B Step 4: t stat = Step 5: Reject H0 Step 6: TISETC < Step 7: P-value = 0.0153 Construct a 96% confidence interval for the true average duration of unemployment in Housto Lower Endpoint Question 5C -2.2329 22.0355 Upper Endpoint 29.7868 Using descriptive statistics off the Excel output generated for parts A and B, construct a 80% co during July 2013. Lower Endpoint 23.5287 Upper Endpoint 28.2935 must be typed to either 2 or 3 decimals depending on whether the Z or t table is appropriate. Please tables provided in STAT 3331 (not the tables in the textbook). must be typed to four decimals must be chosen from drop down menu must be derived using cell references significant evidence to conclude not significant evidence to conclude by Using the TI-30XA Calculator til you reach your answer, then round to four decimals. hicles are not covered by insurance. Simple results, consistent with the CNBC rcise 36 on page 369 of your textbook for a similar problem.) different from 16% at =0.05? 0.16 0.16 1.96 The smaller number must be typed first. -1.96 or z stat > 1.96 0.16 he lower boundary must go on the left and the upper boundary on the right. es not covered by insurance. (the population variance is known): (-268.7928, 83.1670) ebt is the third largest source of household indebtedness. The following data on page 354 of your textbook for a similar problem.) o less than $6630 at =0.005? 6630 6630 3.106 -3.106 d. The smaller number must be typed first. or 6630 The lower boundary must go on the left and the upper boundary on the right. < 0.995 ard balance. athematically manipulate the P-value from part A to get your answer) go on the left and the upper boundary on the right. 0.02 and 5 by Using the Excel Output ng. Use the data in the Texting sheet in this workbook to generate excel output w MUST reference Excel output cells in the Texting sheet. t while driving at alpha=0.01? 0.43 0.43 2.33 2.33 d. The smaller number must be typed first. or 0.43 n motorists who text while driving. sample of unemployed Houstonians how many weeks they have been enerate excel output to answer the following questions. Each orange numerical eet. ston is less than the national average of 30 weeks during July 2013 at alpha=0.025? 30 30 2.015 -2.015 d. The smaller number must be typed first. or 30 unemployment in Houston during July 2013. and B, construct a 80% confidence interval for the true average duration of unemployment in Houston HOMEWORK ANSWER COMMENTS: 1 Type of problem: Inference for p, n large 2 Remember, the left and right endpoints are the same distance from xx 3 Type of problem: Inference for , unknown 4 Type of problem: Inference for p, n large 5 Type of problem: Inference for , unknown Texting? No No No Yes No No No Yes Yes Yes Yes No No No Yes Yes Yes Yes No Yes No No No No No Yes Yes Yes Yes No No No Yes No Yes Yes No No Yes No No No No Yes Yes No No The Excel output for this data must start in D11. (That m MUST follow the templates in the CHAP8&9 sheets in th Texting? Sum - Texting? No Yes Total Result P` #DIV/0! Yes No Yes Yes Yes Yes Yes No No No No Yes Yes No Yes No No No Yes Yes No Yes No Yes Yes No No Yes Yes Yes No Yes Yes No Yes No No Yes No Yes Yes No Yes Yes Yes No Yes Yes Yes No No No Yes No No No Yes Yes No No Yes No Yes No No No No No Yes Yes Yes No Yes Yes Yes Yes Yes Yes No Yes Yes Yes No No No No No No No No Yes Yes Yes Yes Yes No Yes No Yes No No Yes Yes Yes No No No No No No No No No No No Yes Yes No No No No Yes No No No Yes Yes No Yes No No No Yes No Yes No Yes Yes No No No Yes Yes Yes Yes Yes No No No Yes Yes Yes Yes No Yes No Yes Yes Yes No No No No Yes Yes Yes No No No Yes Yes No Yes No Yes No Yes Yes No Yes Yes Yes No Yes Yes No Yes No Yes Yes Yes Yes Yes No Yes No No No No No No No No Yes Yes Yes Yes No Yes No Yes Yes No No Yes Yes Yes Yes No No Yes Yes Yes Yes Yes Yes Yes No No Yes Yes No No Yes Yes No Yes No No No Yes No No Yes No No Yes No No Yes Yes Yes Yes No Yes No Yes Yes No Yes No Yes No Yes No Yes Yes No Yes Yes Yes No No No Yes No Yes Yes Yes Yes No No No No No No Yes Yes No No Yes Yes Yes No Yes No Yes No Yes Yes Yes No Yes Yes No No No Yes No Yes Yes Yes Yes No No No No No No No Yes Yes Yes No No No No Yes No Yes Yes No Yes Yes Yes Yes No No Yes Yes Yes Yes Yes Yes Yes No No Yes No Yes No No Yes No No Yes No No Yes No No No No No No No Yes No No Yes Yes No Yes Yes No Yes No No No Yes Yes Yes No Yes Yes Yes No No Yes No No Yes No No No No No Yes Yes No Yes Yes Yes Yes Yes No Yes No Yes No No No Yes No Yes No No Yes Yes Yes No No No Yes Yes No Yes Yes Yes No Yes No Yes Yes Yes Yes No Yes Yes No Yes Yes Yes No No Yes Yes Yes No Yes Yes No No Yes Yes Yes No Yes No Yes Yes No No Yes No Yes No Yes Yes No Yes Yes Yes No Yes Yes No Yes Yes No No No Yes Yes Yes No Yes Yes Yes No No No Yes Yes Yes Yes Yes Yes Yes No Yes No Yes No No Yes Yes Yes No Yes Yes Yes Yes No No No Yes Yes Yes No No No Yes No Yes No No No Yes No No No No No Yes No Yes Yes No No No No No No No No Yes Yes No No No No No in D11. (That means E11 should have the label for the dataset.) You &9 sheets in the Excel Templates spreadsheet to receive full credit. Solution Response of Interest Texting? Yes Sample Size Count for Response Sample Proportion 600 303 0.5050 Confidence Interval Confidence Coefficient 0.84 Lower Limit 0.4763 Upper Limit 0.5337 Hypothesis Test Hypothesized Value z Test Statistic Pts Of -3 -4 0.43 3.7108 -4 P-value (LST) P-value (RST) P-value (2ST) -4 0.0002 Deductions Incorrect Answers Points Lost -15.0 -15.0 Formatting 4 Decimal Places Bold Font Correct borders Column Width 0 0 0 0 Label Correct Points Lost 0 -3.0 Total Score Max Possible Total Points Lost: Final Score: 15.0 -18.0 0.0 ou it. Weeks Unemployed 17 37 45 20 40 14 The Excel output for this data must start in D11. (T MUST follow the templates in the CHAP8&9 sheets 12.2842 25 10 43 17 Weeks Unemployed 33 9 12 45 44 17 39 40 18 33 20 23 35 43 10 45 14 19 33 8 16 14 15 18 20 9 10 24 45 33 38 36 24 31 25 Mean Standard Error Median Mode Standard Deviation Sample Variance Kurtosis Skewness Range Minimum Maximum Sum Count Confidence Level(95.0 25.9111 1.83122 24 45 12.2842 150.901 -1.39183 0.2102 37 8 45 1166 45 3.69058 must start in D11. (That means E11 should have the label for the dataset.) You he CHAP8&9 sheets in the Excel Templates spreadsheet to receive full credit. Solution Weeks Unemployed Sample Size 45 Sample Mean Sample Standard Deviation 25.9111 12.2842 Confidence Interval Confidence Coefficient Lower Limit Upper Limit 0.96 22.0355 29.7868 Pts Of -3 -4 Hypothesis Test Hypothesized Value t Test Statistic P-value (LST) 30 -2.2329 -4 P-value (RST) 0.9847 -4 P-value (2ST) el for the dataset.) You t to receive full credit. tion Deductions Incorrect Answers Points Lost -15.0 -15.0 Formatting 4 Decimal Places Bold Font Correct borders Column Width 0 0 0 0 Label Correct Points Lost -3.0 0 Total Score Max Possible Total Points Lost: Final Score: 15.0 -18.0 0.0