Lab 1- HOMEWORK

Research and Statistics II

1. Open the file Lab_1_Homework.xlsx
   1. Dr. Bummedout is interested in the effects of weather on mood. Specifically, she predicts that the number of non-sunny (overcast) days per year is related to depressive state. She has collected relevant info about each of these variables (listed below). She has also recorded each participant's family history of depression.

History: Family History of Depression - 1=Negative, 2=Positive

Days: Non-sunny days per year

Score: Score on Hamilton Depression Scale

1. Fill in the two tables below.
   1. Mean, Median, Mode, SD

	DAYS	SCORE
MEAN	168.23	11.00
MEDIAN	151.50	7.00
MODE	134	2.00
STANDARD DEVIATION	69.83885	10.11138
SKEWNESS	0.701208	1.55353
KURTOSIS	-0.38002	2.737849

1. Skewness and Kurtosis

	DAYS	SCORE
Is distribution skewed??	Y N If yes: + skew - skew	Y N If yes: + skew - skew
Is distribution kurtotic?	Y N If yes: leptokurtic platykurtic	Y N If yes: leptokurtic platykurtic

1. Generate a Frequency Table and Histogram for the "Days" Variable. Here, the histogram generated by MagicStat is more informative than the histogram in Excel.

1. Answer the following question:

How well does the distribution of days match up with a normal curve? Provide evidence for your answer.

1. Using Excel, MAKE a bar graph comparing the depression score for those who are family history positive to those who are family history negative. Do not truncate the range. Hint: follow the same steps from the lab exercise to generate the means and standard error of the mean values as well as create the graph.
   1. Answer the following question:

Describe the bar graph. Which group has a higher depression score?

1. MAKE a scatterplot for the variables Days and Score. Again... follow the instructions from the lab exercise to generate the scatterplot.
   1. Answer the following question:

What is the relationship between the number of non-sunny days/year and depression score?