| 
 
 
| Question 350687:  HELP!!! I am completely lost in statistics!! Any assistance is greatly appreciated!
 I need help with the following questions:
 A survey of randomly chosen new students at a certain university revealed the data below
 concerning the main reason for choosing this university instead of another. Research question: At α = .01, is the main reason for choosing the university independent of student type? Students
 New Student 	Tuition 	Location	Reputation	Row Total
 Freshmen	 50 		30 		35 		115
 Transfers 	15	 	29	 	20	 	64
 MBAs		 5 		20	 	60	 	85
 Col Total	70	 	79	 	115	 	264
 and
 Final exam scores for a sample of 20 students in a managerial accounting class are shown. (a) At α = .05, is there a difference in the population median scores on the two exams? Make an Excel worksheet for yourWilcoxon signed-rank test calculations and check your work by using MegaStat or a similar computer package. (b) Perform a two-tailed parametric t test for paired two-sample means by using Excel or MegaStat. Do you get the same decision? Accounting
 Student	 Exam 1	 Exam 2	 Student	 Exam 1	 Exam 2
 1 		70	 	81	 	11	 	84	 	96
 2 		74	 	89	 	12	 	95	 	96
 3 		65	 	59	 	13	 	83	 	99
 4 		60	 	68	 	14	 	81	 	76
 5 		63	 	75	 	15	 	59	 	68
 6 		58	 	77	 	16	 	54	 	47
 7 		72	 	82	 	17	 	75	 	84
 8 		71	 	69	 	18	 	92	 	100
 9 		52	 	53	 	19	 	70	 	81
 10 		79	 	84	 	20	 	54	 	58
 
 Answer by stanbon(75887)
      (Show Source): 
You can put this solution on YOUR website! I need help with the following questions: A survey of randomly chosen new students at a certain university revealed the data below
 concerning the main reason for choosing this university instead of another. Research question: At alpha = .01, is the main reason for choosing the university independent of student type?
 -----------------
 Students
 New Student 	     Tuition 	Location	Reputation	Row Total
 Freshmen	        50 		30 		35 		115
 Transfers 	15	 	29	 	20	 	64
 MBAs		 5 		20	 	60	 	85
 Col Total	70	 	79	 	115	 	264
 ----------------
 Ho: Row and Column factors are independent
 Ha: Row and Column factors are not independent
 I ran a Chi-Sq Test of the 3 by 4 set of data and got the following:
 ---
 Chi-Sq = 54.1768
 p-value = 0.000000000048325
 ===================================================
 Since the p-value is less than 1%, reject Ho
 Conclusion: The test results do not support Ho.
 ===================================================
 Cheers,
 Stan H.
 
 | 
  
 | 
 |