Reference no: EM133480309
Assignment
Using the skills you learned in Unit 5: Assignment #1, and using your chosen data management platform, calculate the mean, the median, and the mode for Course A and for Course B in the Final Grade Data Set.
First, download the .csv file, Final Grade Data Set, which includes hypothetical final course grades (as percentages) from two hypothetical courses, Course A and Course B.
If you are using the browser Chrome or the browser Firefox, click on the link for your data set, below. When prompted, save the file to your PSY-210_Summer2021_Unit05 folder.
If you are using the browser Safari, right-click on the link for your data set, below, and select "Download Linked File."
Second, import the Final Grade Set .csv file into a blank spreadsheet in your chosen data management platform.
Remember to follow Andrews' (2020) Import Data how-to article.
Then, save the new spreadsheet in which you have imported the Final Grade Data Set, naming the file, YourLastName_PSY-210_Unit05_FinalGradeData
Third, using your chosen data management platform, calculate the mean, the median, and the mode for Course A.
Write down the mean, the median, and the mode for Course A.
When you need to use decimals (which you will need for reporting the mean and the median), remember to use three decimal places (e.g., 70.755%).
If your data management platform converts percentages (e.g., 70.755%) to proportions (e.g., .70755), you will need to search the Internet for a how-to guide to learn how to use your data management platform to convert proportions (e.g., .70755) back to percentages (e.g., 70.755%).
Fourth, using your chosen data management platform, calculate the mean, the median, and the mode for Course B.
Write down the mean, the median, and the mode for Course B.
When you need to use decimals (which you will need for reporting the mean and the median), remember to use three decimal places (e.g., 70.755%).
If your data management platform converts percentages (e.g., 70.755%) to proportions (e.g., .70755), you will need to search the Internet for a how-to guide to learn how to use your data management platform to convert proportions (e.g., .70755) back to percentages (e.g., 70.755%).
To become familiar with what variability is and how it is measured, read Open Statistics Education's (n.d.) "Measures of Variability."
To learn how to calculate three measures of variability - the range, the variance, and the standard deviation - search the Internet for tutorial or how-to guides that are specific to your chosen data management platform.
Some how-to guides may cover the range, the variance, and the standard deviation all in one tutorial. Other how-to guides may cover only the range in one tutorial, the variance in another tutorial, and so forth. Again, that's ok. But you need to find a how-to guide for calculating
the range,
the variance, and
the standard deviation.
The how-to guides you find can be in any format (video, written text, figures, or the like - or a combination of formats). However, all the how-to guides you find must be from the Internet and not from other sources (e.g., textbooks or friends).
After you've found a how-to guide (or guides) for calculating the range, the variance, and the standard deviation using your chosen data management platform:
Use your chosen data management platform to calculate the range, the variance, and the standard deviation for Course A.
Write down the range, the variance, and the standard deviation for Course A.
When you need to use decimals, remember to use three decimal places
The range and the standard deviation are reported in their original units, which will be percentages for these data (e.g., 6.932%); however, the variance is not reported in its original units because the variance is calculated in squared units.
Use your chosen data management platform to calculate the range, the variance, and the standard deviation for Course B.
Write down the range, the variance, and the standard deviation for Course B.
When you need to use decimals, remember to use three decimal places
The range and the standard deviation are reported in their original units, which will be percentages for these data (e.g., 6.932%); however, the variance is not reported in its original units because the variance is calculated in squared units.
Go to the Unit 5: Assignment #2 Discussion Board and make a new Discussion Board post in which you do the following:
First, define in your own words and in no more than one sentence, each of these three measures of variability:
the range
the variance
the standard deviation
Second, embed the three links to the three how-to guides you found and used to calculate the range, the variance, and the standard deviation in your chosen data management platform.
Be sure to embed one link for EACH of the three measures of variability (one for the range, one for the variance, and one for the standard deviation).
If you used the same how-to guide for learning more than one measure of variability, you should embed the same link more than once (you should have three links total).
Remember to embed your links using the procedures you learned from the Course How To.
Third, report the mean, the median, and the mode that you calculated for Course A, using statements such as
The mean final grade in Course A = xx.xxx%
The median final grade in Course A = xx.xxx%
The mode final grade in Course A = xx%
Fourth, report the mean, the median, and the mode that you calculated for Course B, using statements such as
The mean final grade in Course B = xx.xxx%
The median final grade in Course B = xx.xxx%
The mode final grade in Course B = xx%
Fifth, report the range, the variance, and the standard deviation that you calculated for Course A, using statements such as
The range of final grades in Course A = xx%
The variance of final grades in Course A = xx.xxx (note that variances are not reported in the original units, e.g., % in this case, because they are in squared units)
The standard deviation of final grades in Course A = xx.xxx%
Fourth, report the range, the variance, and the standard deviation that you calculated for Course B, using statements such as
The range of final grades in Course B = xx%
The variance of final grades in Course B = xx.xxx (note that variances are not reported in the original units, e.g., % in this case, because they are in squared units)
The standard deviation of final grades in Course B = xx.xxx%