Question
For #1-2 , use the dataset HW_Dataset1. Report means extracting the requested numbers from the output and putting them in writing. #1. For the variable
For #1-2, use the datasetHW_Dataset1."Report" means extracting the requested numbers from the output and putting them in writing.
#1. For the variable MONEY, calculate in Excel standard deviation and variance step-by-step like it was shown in the video Lecture 04. Include a screenshot with all the columns and calculations (at least 10 rows should be visible on the screenshot). Report the variance in the following format:
Variance= ...
#2. For the variable MONEY, using the Data Analysis Toolkit in Excel, find the range, standard deviation, and variance. Include a screenshot with the resulting descriptive statistics. Report the range, mean, and standard deviation in the following format:
Range= ...
M= ...
SD= ...
#3. Researchers wanted to explore change with age (monthly from 6 to 18 months) in problem-solving skill (measured on a scale 0-100) for infants born preterm vs. full-term. What are the independent and dependent variables? Specify the type of each variable (categorical vs. continuous).