Answered step by step
Verified Expert Solution
Question
1 Approved Answer
You would like to determine the SD for the variable Scholarship Amount and enter the data into Excel as the following: A B C D
You would like to determine the SD for the variable Scholarship Amount and enter the data into Excel as the following: A B C D X X - mean (X - mean) 2 1000 W 2000 4 7000 UT 4000 8000 7 8000 8 5000 9 2000 10 4000 11 4000 12 Sums of Squares 13 Variance 14 Standard Deviation Use the image above to answer the questions below.Question 14 1 pts The first step you would need to take to calculate the SD is to determine the mean of X. Select the syntax that you would use in Excel to derive this value. O =MEAN(A1:A11) O =AVERAGE(A1:A12) O =XMEAN(A2:A11) O =AVERAGE(A2:A11) Question 15 1 pts The next step you would need to take would be to determine the deviation scores. Select the syntax that you would use in Excel to derive this value in cell B2. O =B2-$B$12 O =A2-$A$12 O =A2-MEAN O =B2-MEAND Question 16 1 pts After calculating the deviations, the next step would be determine the squared deviations. Select the syntax that you would use in Excel to derive this value in cell C2. O =A2*B2 O -B2*B2 O -SQUARE(B2) O =SQUARE(C2) D Question 17 1 pts After calculating the squared deviations you can then calculate the sum of squares, the variance, and the standard deviation. Match the terms on the left to the respective formula you would use in Excel on the right. Sums of Squares [ Choose ] [ Choose ] SQRT(C13) Variance SUM(C2:C11)*2 -SUM(C2:C11) =C12/9 -STDEV(C2:C11) Standard Deviation -C12/10Below are the descriptives (Mean, Median, Mode, and SD) for 10 different variables (Variables 1 to 10). A B C D E Mean Median Mode SD 2 Variable 1 17.00 15 19 5.52 3 Variable 2 27.80 19 11 9.42 4 Variable 3 14.20 16 18 4.08 5 Variable 4 17.00 18 17 12.54 6 Variable 5 14. 10 19 16 5.56 7 Variable 6 17.60 15 17 5.65 Variable 7 17.50 18 18 0.75 9 Variable 8 13.90 18 15 4.36 10 Variable 9 10.20 14 19 5.27 11 Variable 10 17.00 17 17 5.25 Use the descriptive statistics shown in the image above to answer the questions below. **Please note that these variables were all measured on the same scale and were therefore expected to have similar descriptive statistics.**Question 18 1pts Which of these variables most likely:r has a platykurtic distribution? 0 Variable 1 0 Variable}! 0 Variable 3 O Variable4 0 Variable 5 0 Variable :5 0 Variable? 0 Variables 0 Variable 9 0 Variable 1o Question 19 1 pts Which of these variables most likely has a leptokurtic distribution? O Variable 1 O Variable 2 O Variable 3 O Variable 4 O Variable 5 O Variable 6 O Variable 7 O Variable 8 O Variable 9 O Variable 10Question 20 1 pts Which of these variables most likely has a positively skewed distribution? O Variable 1 O Variable 2 O Variable 3 O Variable 4 O Variable 5 O Variable 6 O Variable 7 O Variable 8 O Variable 9 O Variable 10Question 21 1 pts Which of these variables most likely has a negatively skewed distribution? O Variable 1 O Variable 2 O Variable 3 O Variable 4 O Variable 5 O Variable 6 O Variable 7 O Variable 8 O Variable 9 O Variable 10
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started