SURVEY ANALYSIS: T-TEST AND HISTOGRAM

management

Description

SURVEY ANALYSIS: T-TEST AND HISTOGRAM
LAST REVISION: 11/10/19 Tasks:
FILENAME: A3 Survey T Tests 1. Do a t-test and histogram w/ chart for each question.
Developer: Curtis Oppelt, 004362864@coyote.csusb.edu 2. Answer the question whether men and women respond differently to each Q.
3. Make sense of t-tests in Row 48.
Shaded areas are user input. Blue font is for formulas.
Gender 1:Men, 0:Women
Use Data, Data Analysis , t-Test to test differences between groups.
Use conservative measure of two groups w/ unequal variances.
Use Data, Data Analysis, Histogram to do histogram analysis.
Gender Q. 1 Q. 2 Q. 3 Q. 4 Q. 5 Sample t-test for Q. 1.
1 2 3 2 5 2   t-Test: Two-Sample Assuming Unequal Variances
1 1 1 2 3 4  
1 3 3 2 4 3     Variable 1 Variable 2
1 4 2 1 4 2   Mean 2.411764706 3.307692308
1 2 3 3 5 5   Variance 1.132352941 1.064102564
1 2 3 3 4 2   Observations 17 13
1 3 5 1 2 1   Hypothesized Mean Difference 0
1 2 5 2 5 4   df 26


Related Questions in management category