Only answer 5 bonus question on page 14 (bottom of pdf). Keep it in line with the questions covered under syllabus and general experience one will have while attending online class.

Discussion QuestionUsing the Excel Sheet and descriptive statistics page; you will write up your analysis for the 20 participants. This week, you learned about the statistical software applications used to analyze data for research analysis. For this week's discussion, you will use Excel sheet provide to run descriptive statistics, create graphs and respond to the following:How could you use Excel descriptive statistics for data analysis research?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?Refer to this week’s readings and video tutorials before starting this two part discussion question assignment. Step 1: Entering DataOpen a blank worksheet in the Excel programYou will now use Excel to view a sample datasetDataset OptionsIn many cases, researchers may have the data from their study in another software package like Microsoft Excel. However, if the data is not available in a software spreadsheet you can manually enter the data. Option 2: Manual Data EntryIn the Worksheet window, type “Age” in C1. Enter the numbers as shown in the dataset below. Enter the remaining data as shown below (set up your column labels i.e., variable). 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. Age Cringe Uneasy Afraid Worried Understand 28 5 3 4 4 3 34 2 5 3 2 1 25 4 4 4 2 5 56 3 4 3 1 2 23 5 4 3 3 4 29 1 5 3 2 3 30 3 3 5 2 5 59 2 5 5 1 2 45 4 2 5 3 3 38 1 2 4 1 1 33 3 2 4 3 2 47 4 2 3 4 5 24 1 5 3 4 4 29 5 4 2 1 3 53 3 1 5 2 1 48 4 4 1 5 3 27 2 5 4 3 4 34 4 4 3 2 5 26 4 5 2 3 2 36 5 5 5 4 3 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. How to Run Descriptive StatisticsNow that your data is in Excel, you will look at the descriptive statistics for this dataset. 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.Discussion Question Part 1How could you use Excel descriptive statistics for data analysis research? Write about your experience running descriptive statistics. Use the results in the Session Window to support your response. Then add to your discussion with the information you learn writing up your analysis.Step 3: Excel and GraphsYou will now look at graphing. 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. Try using the histogram feature for one of the variables and select "Ok". You can create other Histogram graphs by choosing different variables. You can also choose from the other ten graph choices shown on the insert chart function.Discussion Question Part 2What 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? Copy and paste your graph(s) in a Word document and attach to your discussion response.

Part I: Descriptive Draft (Descriptive Statistics) choose a topic of interest and performing a simple experiment. The sample size for experiments, at least 20. You will submit a descriptive draft to portray the data that was collected, explain the variable or variables being summarized and displayed, and why that variable was chosen. Organization of the descriptive draft should be as follows: (The Project Template is included on the final page of these instructions.) · Introduction: One or two paragraphs introducing and detailing the project topic, how inquiry(ies) were conducted, and the relevance of the group’s project to a well-defined community. Include any national statistics that support the importance of the issue or that will be used for comparison to the data. This section should end with a one-sentence purpose statement and primary research question(s). · Method: Two or three paragraphs containing the details of the group’s study, a description of the research objective(s)/hypothesis(es), type of study, participants, variables measured, and sampling technique. Numerical summaries and graphs of the data should be embedded throughout this section, along with the descriptions. · Provide at least 3 different numerical summaries and displays of the data, as appropriate for the chosen topic and variable(s). Examples may include mean, median, standard deviation, 5-number summary, linear correlation coefficient, and/or linear regression equation; pie chart, Pareto chart, frequency/relative frequency distribution, histogram, stem-and-leaf plot, and/or scatter plot. · Chapter 1 of the textbook provides helpful information about population parameters, sample statistics, sampling methods, and bias. Chapters 2, 3 and 4 provide helpful definitions, instructions and examples for summarizing and displaying both qualitative and quantitative data. Part II: Final Draft (includes Inferential Statistics) Each student will submit a final draft that answers a specific question or questions about a population defined by interest. Inferential statistics should include the following points: (The Project Template is included on the final page of these instructions.) · Assumptions about the population, sampling distribution, or other facets of the investigation · Clear hypotheses (e.g., null and alternative hypotheses) about one or more qualitative or quantitative variables of a well-defined population · Findings: Analytical summaries such as confidence interval and/or P-value, including a proper interpretation · Findings: Speculation upon the meaningfulness of results, as well as the limits and/or consequences of any statistical inferences · Chapters 4, 9 and 10 of our e-text provide helpful definitions, instructions and examples for completing Part II, such as testing for linear correlation (chapter 4), interpreting confidence intervals (chapter 9), or formulating and interpreting hypothesis tests (chapter 10). Students in the same SIP group will be using the same data. As such, each student in the same group may start with the same basic template, but each student must write her/his own Findings and Conclusions. Each student will submit their final draft in Canvas as a Microsoft Word document The project will be based on Qualitative Experiment  Method Several (at least 2-3) paragraphs that contain the details of your study, a description of your research objective(s)/hypothesis(es), type of study, participants, variables measured, and sampling technique. Numerical summaries and graphs of your data should be embedded throughout this section along with descriptions. See Part I: Descriptive Draft (Descriptive Statistics) of SIP-Assignment Instructions document. Findings Two to three paragraphs addressing inferential analyses and conclusions drawn about specific variables within a well-defined population (make clear null and alternative hypotheses). Identify assumptions made about your population, the sampling distribution of your sample statistic, or any other facet of your investigation, and the limits of your conclusions. Include a P-value and/or a confidence interval as needed and interpret it. Use visuals as necessary. See Part II: Final Draft (Inferential Statistics) of SIP-Assignment Instructions document. Conclusion One paragraph summary regarding the overall meaningfulness of the statistical inquiry and the lessons learned about project development and completion. References Cite any sources used to develop background information. Cite any source of national, state, or local statistics used as a null hypothesis. Appendix Raw data from the experiment or survey study must be included here. In addition, if an online survey was launched, a live link must be provided. Or, if live interviews or simple experiments were conducted, provide details such as dates, times, places, and names of group members involved.