1. Calculate a Sum for each person in the study. This should result in a column at the end of the data that is a sum of all the scores in that row. The higher the sum, the more optimistic the person is. Sums = 30 is the highest level of optimism.
2. Calculate a Mean, Median, Mode, and Standard Deviation for this Sum column for both men and women. This will tell you how optimistic women and men were as a group in the study. The higher the mean the higher the optimism. This should automatically populate.
3. Create two polygons-- one for the data for men and one for women and determine if the distributions are normal or skewed. If the polygon chart does not automatically populate you will have to manually type in your frequency.
4. Look at the mean, median, mode, and standard deviation and describe how these measures of central tendency indicates whether the distribution of men and women are normal or skewed. That is, is the distribution of men and women normal or skewed? How does the mean, median, and mode scores indicate if the distribution is normal or skewed?
5. Look at the table of raw data for both men and women. Explain why the raw numbers indicate the distribution is normal or skewed. If the distributions are normal how would the scores have to change to yield a skewed distribution? If the distributions how would the scores have to change to yield a normal distribution.
6. Include textbook content to assist with your answers above and be sure to include proper citation of the textbook in your results section. The textbook could be used as your third additional resource.

1. P Value and Optimism Study:

After all your data is in you will see your p-value for your independent t-test populate.Rememberthis independent t-test is used to analyze if the difference between two groups is statistically significant.This test is based off of the 15 females and 15 males. If you have trouble seeing the p-value populate you can always put in the formula into

File Home insert Page Layout Formulas Data Review View Help Chart Design Get Add-ins PivotTable Recommended Table Illustrations Recommended 6 My Add-ins PivotTables Charts Tables Add-ins Charts Chart 2 V : XVfx A B C D m F G H GENDER Q1 Q2 Q3 Q4 Q5 06 SUM OF ROW 3 4 4 5 4 23 F F 5 3 51 5 27 UT UT UT W UT 1 5 23 F 2 YOUOWN F 5 5 24 F 5 3 23 NAW H AWW W UT D UT 23 22 20 D W UT W D 25 23 NAW W WH HUUH 22 19 Frequency 23 U D W 14 WA w 24 W w w 19 TI 1 3 19 21 22 23 24 + 25 26 27 Mean 22.67 Classes 28 Optimism Data + Ready Accessibility: Investigate 56OF O SunnyCalibri 11 A A E de Wrap Text E Merge & Ce Paste BIU v U v. A v Alignment Clipboard Font 1do V : X V fx =TTEST(H2:H16,H43:H57,2,3) E F A C D G H B 26 to 2 28 to 2 30 to 3 Q1 Q2 Q3 Q4 Q5 Q6 SUM OF ROW GENDER 23 M 4 5 4 4 M 3 5 5 27 23 M A DUI UT UT UT 24 w 3 5 23 V W V 23 W N W N BN 0. S AW 3 Frequency W W W W W UT D 0.6 23 W U D W 3 24 M 19 0.4 0.2 164 165 66 Optimism Data Ready 7% Accessibility: Investigate 560F Sunny O