Week 9 Discussion
KLeyva
week_9_discussion.docx.docxHow could you use Excel descriptive statistics for data analysis research?
Having run the data through the statistics add-in in Excel, I see that there are several bits of information that it produces. Descriptive statistics measure central tendency (Gray, Grove, & Sutherland, 2016). This type of analysis helps summarize and organize the data so it can be understood in simple terms. It seeks to describe the data but not make any inferences about it. This can be used to describe demographics of the test population. For my study, it can be used to describe the population of each study group. This analysis can test whether there is a random and or equal distribution for the demographics.
For the data in this discussion, the mean age is 36.2 in this group. It is also of note that the mean for almost every emotion is about in the center of the scale, except worried. For that same variable, the standard deviation is relatively low. This can indicate that the spread in the data is about the same as the other variables. The largest standard deviation is for age. This happens because the spread of the data range is from 23 to 59 years of age.
|
Variable |
N |
N* |
Mean |
SE Mean |
StDev |
Min |
Q1 |
Median |
Q3 |
Maximum |
|
Age |
20 |
0 |
36.2 |
2.512 |
11.232 |
23 |
27.250 |
33.500 |
46.5 |
59.000 |
|
Cringe |
20 |
0 |
3.25 |
0.3067 |
1.3717 |
1 |
2.0000 |
3.5000 |
4.00 |
5.0000 |
|
Uneasy |
20 |
0 |
3.70 |
0.2911 |
1.3018 |
1 |
2.2500 |
4.0000 |
5.00 |
5.0000 |
|
Afraid |
20 |
0 |
3.55 |
0.2562 |
1.1459 |
1 |
3.0000 |
3.5000 |
4.75 |
5.0000 |
|
Worried |
20 |
0 |
2.65 |
0.2542 |
1.1367 |
1 |
2.0000 |
2.5000 |
3.75 |
5.0000 |
|
Understand |
20 |
0 |
3.05 |
0.3033 |
1.3563 |
1 |
2.0000 |
3.0000 |
4.00 |
5.0000 |
What are your plans for learning more about Excel and how will the information you learned about this software be of benefit in your future analysis of research data?
This section of information has been challenging for me for sure. When I took statistics for my MBA it was twenty years ago. Features in Excel were quite a bit more rudimentary than the version we use today. Today’s version made the data analysis so much easier. Being able to click on the desired statistical analysis is 100% easier than typing in the formulas by hand. Excel will make future research data analysis simpler and possibly manageable without consulting with a statistician.
References
Gray, J., Grove, S., & Sutherland, S., (2016). Burns and Grove’s The practice of nursing research: Appraisal, synthesis, and generation of evidence. (8th ed.), Elsevier: St, Louis: MO
Afraid Histogram
4 3 4 3 3 3 5 5 5 4 4 3 3 2 5 1 4 3 2 5
