The Use of Excel to Complete Statistical Analysis .

Posted: January 3rd, 2023

The Use of Excel to Complete Statistical Analysis .

Discussion forum week 6 (graded):

This week’s content focused on topics related to statistical analysis. Basic terms related to statistics, and information pertaining to different processes (e.g. mathematical equations, software) for data analysis were presented. In addition, phase 3 of the case study was presented. For assignment #2 you will use Excel to analyze a dataset. To help you prepare for this assignment, complete the following activities:The Use of Excel to Complete Statistical Analysis .

ORDER A PLAGIARISM-FREE PAPER HERE

1. Perform a brief self-assessment regarding your knowledge, comfort level, and experience with using Excel to complete statistical analysis. Based on your assessment findings, identify your areas of greatest weakness.

2. Access the excel tutorials found within “24/7 Technology Training” (web based software). You can access this under the “Tools” page. Click on the 24/7 Technology Training box. Then, select the search option. Use a variety of search terms (e.g., Excel; Excel and Statistical Analysis) to explore available tutorials. Select at least 3 tutorials to view / complete related to your identified weaknesses.

3. Based on the three tutorials you reviewed create a tip sheet to share with your peers. The tip sheet should contain the following items: 1) Title of the tutorial, 2) Main learning objective(s) of the tutorial, 3) Key take away points.

4. Provide a brief summary of your self-assessment (3 – 4 sentences) and the tip sheet (attached as a word document) for your main discussion posting. Remember to download and save peers’ tip sheets for your use in NUR 704 (project design) and NUR 799 (project evaluation) or MSN Practicum or Capstone courses.The Use of Excel to Complete Statistical Analysis .

Case Study – Phase 3

Case Study – Phase 3

The clinicians return to the literature to identify an appropriate benchmark for validating the project’s outcome. A study conducted by Robb (2015) is selected for comparison purposes. The clinicians identify the project being implemented in the community clinic mirrors this study. The clinicians, like the Robb (2015) study, are planning to collect data following a pre / post-test approach. Robb (2015) concluded a 20% increase in the group mean total scale score of self-efficacy for chronic disease management resulted from individualized educational sessions. The clinicians select this finding as the benchmark for the project.The Use of Excel to Complete Statistical Analysis .

Robb, M. (2015). The effectiveness of individualized education sessions on client’s self-efficacy for chronic disease management. Journal of Evidence-Based Clinical Practice, 6(2), 38-48.The Use of Excel to Complete Statistical Analysis .

Note: The above citation is hypothetical for the purposes of the associated activities and assignments.

Question 1.
The use of Excel to complete statistical analysis has been helpful in data organization, manipulation, exploration and visualization, as well as conducting numeric computations. The charging feature has been particularly useful owing to its reporting capabilities. However, the personal experience reveals that using Excel is challenging with regards to formulas. Identifying the specific formula to use is a challenge, especially when a range of options are presented with each option presenting a different result. For instance, there are five formulas for calculating the average from a collection of values: AVEDEV, AVERAGE, AVERAGEA, AVERAGEIF, and AVERAGEIFS. To take another example, there are six formulas for calculating variance: VAR.P, VAR.S, VARA, VARPA, VAR, and VARP. Another challenge is that the Excel software interface is cluttered with many features that are not useful in routine activities thus making it difficult to find the features that are needed. For instance, finding the data analysis toolpak could be a challenge for first time users who are forced to navigate through many features before finding the toolpak. The two challenges make it difficult to effectively use Excel for statistical analysis.The Use of Excel to Complete Statistical Analysis .
Question 2.
Table 1. Tip sheet
Title of the tutorial Main learning objective(s) Key take away points
How to Run Descriptive Statistics in EXCEL® Using the Analysis ToolPak How to navigate the Excel software and use the Analysis toolpak to conduct descriptive analysis.
How to specify the input data and output statistics, i.e. summary statistics and confidence level for mean. The analysis toolpak has easy to follow steps with step-by-step directions on how to conduct descriptive analysis.The Use of Excel to Complete Statistical Analysis .
How to Calculate a Difference in Means and Percent Change in Means Using EXCEL® Output Comparing mean scores for two different time periods for the same population sample to indicate changes experienced over time. There are cases when formulas are not useful, and there is a need to conduct manual calculations.The Use of Excel to Complete Statistical Analysis .

The tutorials were helpful in addressing the two challenges. Firstly, the tutorials helped me to familiarize with the appropriate formulas for each data set. To be more precise, it showed that the data analysis toolpak can help in identifying the appropriate formulas. Secondly, the tutorials helped me to be more familiar with navigating the different Excel features and picking out the required tools for use.The Use of Excel to Complete Statistical Analysis .