Hello, I need help with this practice problem, it is for Quantitative Analysis for Business. Could you also show how to do it on excel please?
Problem 1
File Insert Draw Page Layout Formulas Data Review View Help Share Home Calibri 11 E General Conditional Formatting Insert 2 AY U v A Format as Table Delete Analyze Sensitivity Paste Data A Cell Styles Format Font Alignment Number Styles Cells Editing Analysis Sensitivity Clipboard H20 X V B C D E F G H K L M N O P Q R S T U V 1 The following shows the number of individuals in a sample of 300 who indicated they support the new tax proposal. 2 3 Political Party Support 4 Democrats 100 5 Republicans 120 6 Independents 80 8 We are interested in determining whether the opinions of the individuals of the three groups are uniformly distributed. Using an a = .05 level of significance to carry out the hypothesis test. (Be sure to say whether you reject or not reject Ho and why) 10 Political Party Observed Frequency 11 Democrats 100 12 Republicans 120 13 Independents 80 14 Total 300 15 16 Hypothesized Probal Expected Frequency 17 0 18 OO 19 20 1 21 22 23 Chi-square values 24 A #DIV/O! 25 B #DIV/O! 26 C #DIV/O! 27 Total #DIV/0! 28 29 30 Test Statistic #DIV/O! 31 P-value #DIV/O! 32 33 Degrees of Freedom Degrees of freedom = k-1 34 35 Critical Value #NUM!File Home Insert Draw Page Layout Formulas Data Review View Help Picture Format Share Cor = General Conditional Formatting Insert 2 B I U v A A = % Format as Table Delete Paste Analyze Sensitivity Data A Cell Styles ~ Format Clipboard Font Alignment Number Styles Cells Editing Analysis Sensitivity Picture 5 X V B C D E F G H J K L M N O P Q R S 1 The results of a recent study regarding exercise and three types of illnesses are shown in the following table. IN 3 Illness No Exercise Exercise Totals 4 Emphysema 32 48 80 Heart problem 60 88 148 6 Cancer 28 42 70 None 150 252 402 Totals 270 430 700 The participants of this study were classified as "Exercisers" if they exercise for at least 30 minutes, at least 3 times per week, at an aerobic pace. Using an =.05 level of significance, is exercising independent of the type of illness? (Be sure to say whether you reject or 10 not reject Ho and why) 11 12 13 14 15 Observed Female Male Grand Total 16 Emphysema 32 48 80 17 Heart Problem 60 88 148 18 Cancer 28 42 70 19 None 150 252 402 20 Grand Total 270 430 700 21 22 23 Expected Female Male Grand Total 24 Emphysema (Row i Total) (Column j Total) 25 Heart Problem Sample Size 26 Cancer 27 None 28 Grand Total 0Insert Draw View Help Share Comment File Home Page Layout Formulas Data Review Calibri 11 ab General Conditional Formatting Insert 2 AY U v A A % Format as Table Delete Analyze Sensitivity Paste Data Format A Cell Styles . Styles Cells Editing Analysis Sensitivity Clipboard Font Alignment Number J34 X V D E F G H J K L M N O P Q R S T A B C 14 15 Observed Female Male Grand Total 16 Emphysema 32 48 80 17 Heart Problem 60 88 148 18 Cancer 28 42 70 19 None 150 252 402 20 Grand Total 270 430 700 21 22 23 Expected Female Male Grand Total (Row i Total) (Column j Total) 24 Emphysema 25 Heart Problem Sample Size 26 Cancer 27 None 28 Grand Total 0 29 30 31 Chi-square Female Male Grand Total 32 Emphysema x 2 = 33 Heart Problem eij 34 Cancer 35 None 36 Grand Total 0 0 37 38 39 Test Statistic Chi-square 0 40 41 P-Value #DIV/O! 42 43 Degrees of Freedom (r - 1)(c - 1) degrees of freedom 44 45 Critical Value #NUM! 46
