Part 1 – Read the attached document, you must respond to at least two other students (Steven + Dany) with substantive feedback. When providing feedback to others in this thread, let each other know whether or not you clearly understand the conclusions.
Part 2 – Statistical Analysis Final Thoughts Reflection
Describe what you consider is the most important thing you have learned and what you will take away from the course. For example, you may want to discuss your improved understanding of a particular statistical test that you think you will use in your future statistic analysis course or career. Or, you may want to discuss your improved understanding of statistics in general and how they are used to shape the way we think about data. Throw back to each week’s module that we have been going through this semester:
Descriptive Statistics, Normal Distribution, and Standard Scores
Correlation and Regression
Hypothesis Testing Basics
Analysis of Variance
Chi-Square and Other Non-Parametric Tests
Selecting and Analyzing Data Sets for Research
Presenting Research Findings
A major client of your company is interested in the salary distributions of jobs in the state of Minnesota that range from $30,000 to $200,000 per year. As a Business Analyst, your boss asks you to research and analyze the salary distributions. You are given a spreadsheet that contains the following information:
A listing of the jobs by title
The salary (in dollars) for each job
Deliverable 1 – Descriptive Statistics_.xlsx
The client needs the preliminary findings by the end of the day. Your boss asks you to first compute some basic statistics and then analyze the results in the four questions given in the Excel spreadsheet.
Background information on the Data
The data set in the spreadsheet consists of 364 records that you will be analyzing from the Bureau of Labor Statistics. The data set contains a listing of several jobs titles with yearly salaries ranging from approximately $30,000 to $200,000 for the state of Minnesota.
What to Submit
Your boss wants you to submit the spreadsheet with the completed calculations, answers, and analysis.
The two news articles in this week’s resources report results from statistical analyses. For this assignment, select a similar news article or one of these. Prepare a written summary and interpretation of the analyses.
Be sure to include the following in your written assessment:
Determine what was measured and then explain how it was measured.
Indicate the type(s) of data included, and the levels of measurement (nominal, ordinal, interval, ratio).
Explain whether the statistical analyses are subject to any measurement errors.
Determine if the results and conclusions are accurate and precise. Then, explain why or why not.
Examine the factors that must be considered when arriving at conclusions after reading such new articles.
Length: 2-3 pages, not including title or reference pages
References: Include a minimum of 2 scholarly resources in addition to citing your selected article.
The completed assignment should address all of the assignment requirements, exhibit evidence of concept knowledge, and demonstrate thoughtful consideration of the content presented in the course. The writing should integrate scholarly resources, reflect academic expectations and current APA standards, and adhere to Northcentral University’s Academic Integrity Policy.
Manipulating the Microsoft Excel Output
Use the graphs and tables from W2 Midweek Assignment (be sure to first make the corrections needed based on your feedback from Week 2).
Create a brief Microsoft PowerPoint presentation describing your sample. Be sure to give an accurate and complete description, taking your instructor’s feedback from W2 Assignment into consideration.
Make necessary corrections to your work on the final project for the first three weeks as per your instructor’s feedback and write:
A comprehensive paragraph describing the participants in the study (from Week 2)
A paragraph describing the major dependent variables of interest (recall and misinformation effect). Be sure to review the Final Project information so you can describe what these variables are, how they were measured, and why they were measured.
The majority of the data is normally distributed if there are enough subjects. For instance, if you collected test scores of only a few honor students, the data will most likely not be normally distributed because you would have a sample that did not represent the entire population. But the identical test scores (for honor students) collected from all schools in a state will result in a normal distribution.
Identify an example of a population that you would expect to be normally distributed. Explain why you believe it would be normally distributed. Then, describe a subset of the population you identified and explain why it would not be normally distributed and what the distribution would look like.
Justify your answers with appropriate reasoning and research from your textbook and course readings. Start reviewing and responding to at least two of your classmates as early in the week as possible. You can ask technical questions or respond generally to the overall experience. Be honest, clear, and concise. Always use constructive language, even in criticism, to work toward the goal of positive progress. Using questions and seeking clarifications are good ways to make your reviews substantive!
Use the appropriate descriptive statistics from W2 Project or run new descriptive statistics for Recall1 using Microsoft Excel.
Assuming that the sample statistics you computed are exactly equivalent to the corresponding population parameters, and using the formula X = (±z)(sd) + M (see below) identify the following:
The exact score on Recall1 that would fall at the upper 5% cutoff (extremely high score?) (Be sure to use the formula given below and round to two decimal places)
The exact score on Recall1 that would fall at the lower 5% cutoff (extremely low score?) (Be sure to use the formula given below and round to two decimal places)
To find these hypothetical scores, solve for X (your raw score) using the following formula, and round to two decimal places:
X = (±z)(sd) + M, where
z = The z-score cutoff for 5 percent in the tail (±1.645)
sd = Your sample standard deviation for Recall1
M = Your sample mean for Recall1
Use Microsoft Excel to compute z-scores for Recall1, following the instructions given in your lecture. Copy the table below into your Microsoft Word document, and complete the table, indicating the appropriate z-scores corresponding to each of the participants whose score is given.
Recall at Time 1
Write a brief paragraph interpreting these z-scores (e.g., how each individual did in relation to the class in terms of the mean and standard deviation of the z-score distribution (not the raw score mean and SD) the percentile the participant would fall into).
Run the t-Test: Two-Sample Assuming Unequal Variances for the Data File Golf (Chapter 10) using the video How to Add Excel’s Data Analysis ToolPak (Links to an external site.) for assistance.
In a managerial report, use the methods of hypothesis testing to
Provide descriptive statistical summaries of the data for each model, written in complete sentences.
Formulate and present the rationale for a hypothesis test that Par could use to compare the driving distances of the current and new golf balls. Clearly state the null and alternative hypothesis.
Analyze the data to provide the hypothesis testing conclusion. What is the p-value for your test? What is your recommendation for Par, Inc.?
Discuss whether you see a need for larger sample sizes and more testing with the golf balls.
Based on your hypothesis testing conclusion, what are your recommendations for Par, Inc? Support your recommendations with findings from your managerial report.
The aim of the experiment is to test the hypothesis that a daily dose of Symphadiol enhances weight loss in clinically obese individuals, compared with just using a calorie-controlled diet. It was decided to select men between the ages of 30 and 40 for the study. It was also decided to look at the impact of exercise in conjunction with Symphadiol.
The intended population of this study are all healthy (other than their obesity) obese male individuals who are sufficiently motivated to lose weight to join a diet network. The individuals must not be taking any medication, except that required for minor ailments.
In total 60 males were recruited between the ages of 30 and 40. Each participant was given a health check prior to the start of the study, their heights were recorded, and they received educational material and diet plans giving details of a calorie-restricted diet (2000 kcal), which they declared they would follow.
All the men attended weekly diet networks where they received support and encouragement from their fellow dieters and the clinical trial specialist nurse. Those individuals following an exercise regime also attended a gym and completed the equivalent of 30 minutes cycling (16 km) three times per week.
The 60 participants were distributed randomly to four experimental groups:
group 1: calorie-controlled diet and placebo.
group 2: calorie-controlled diet and Symphadiol.
group 3: exercise regime, calorie-controlled diet and placebo.
group 4: exercise regime, calorie-controlled diet and 35mg Symphadiol.
In this example, objective was to test the hypothesis that a daily dose of Symphadiol enhances weight loss in clinically obese individuals, compared with just using a calorie-controlled diet. In the experiment described above the independent variable is the treatment group (either Symphadiol treated or control) the patients are assigned to, while the dependent variable is the weight loss. Weight loss is the variable that will be measured.
In the Symphadiol trial, select appropriate group of participants and write two null hypotheses.