Try using the histogram feature for one of the variables and select “Ok”. Select insert graph located at the top of the sheet highlight the data you want to use for a chart select the type of chart select ok.
Then add to your discussion with the information you learn writing up your analysis. Use the results in the Session Window to support your response. How could you use Excel descriptive statistics for data analysis research? Write about your experience running descriptive statistics. Select the data in all the columns except the top that has words for the columns however you have the file already completed and a picture of the descriptive statistics.See end of page for a copy of the excel sheet and descriptive statistics output. Now that your data is in Excel, you will look at the descriptive statistics for this dataset. Step 2: Click on Excel tab for Add Ins if you do not see statistics you will need to open the file option click on Add ins click on ok a box will open which will allow you to choose Statistics package place a check mark in the box and click ok. The measure reflects math anxiety and the study variables (cringe, uneasy, afraid, worried, understand) the math anxiety range is from 1–5 with low being the least and 5 the highest. Enter the remaining data as shown below (set up your column labels i.e., variable). Enter the numbers as shown in the dataset below. In the Worksheet window, type “Age” in C1.
However, if the data is not available in a software spreadsheet you can manually enter the data. In many cases, researchers may have the data from their study in another software package like Microsoft Excel. You will now use Excel to view a sample dataset DATASET OPTIONS Step 1: Entering Data OPEN A BLANK WORKSHEET IN THE EXCEL PROGRAM You will also have access to the Assignment Resources Step-by-Step Guide, accessed through the Assignment Resources Icon located to the right of the grading criteria above. Refer to this week’s readings and video tutorials before starting this two part discussion question assignment. 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?.