Attached is the excel file but I need a Word Document to explain the below.
Please submit a word documentand also a separate EXCEL Spreadsheet with the required calculations. Make sure you submit EXCEL spreadsheet separately and avoid posting the calculated values and the required graph inside your word document as they will not be accepted. Inside the word document, provide discussion by fully addressing the following tasks. I strongly suggest you attend the live chat presentation or view the archived chat session to learn how to perform the required calculations inside EXCEL spreadsheet.
You are required to use the grading comments for Week 4 IP assignment to revise your Week 4 EXCEL spreadsheet and word document postings and to include these Phase 4(IP) revised postings as the first two parts of Phase 5(IP) assignment. Then, you need to complete and add Parts 3 and 4 to complete and submit the final project. A student who does not include the first two parts of the project will risk a substantial point deduction for Phase 5(IP) assignment.
In case you do not include the first two parts (from Week 4 IP) in your final project EXCEL calculations and the Word Document, you will obtain a low score for Phase 5(IP) assignment. So, it is very important for you to carefully read and to follow the Instructor Comments of this final project in order to obtain a high score. In case you want to repurpose your postings from another MATH301 course section, you are required to modify your old postings to meet the requires tasks stated under Instructor Comments of this online course and the way shown inside live chat presentation in order to receive full credit. You can contact the instructor if you have any questions about this.
During Week 4, you completed two parts related to Silver Gym’s data related to body fat and body weight (in pounds) of its 252 members. During Week 5, you are asked to follow the suggestions made by the instructor inside Phase 4 (IP) grading comments to revise your submitted posting from Week 4, and also to complete Part III and Part IV shown below in order to complete and submit Phase 5(IP) or the Final Project the way explained inside Week 5 live chat presentation.
You are hired as a statistical analyst for Silver’s Gym, and your boss wants to examine the relationship between body fat and body weight in men who attend the gym. After compiling the data for body weight ( in pounds) and body fat (as percent of body weight) of 252 men who attend Silver’s Gym (sample), you find it relevant to examine the statistical measures and to perform hypothesis tests and regression analysis to help make general conclusions for body fat and weight in men.
Part I: Statistical Measures(Week 4 Revised)
Statistics is a very powerful topic that is used on a daily basis in many situations. For example, you may be interested in the age of the men who attend Silver’s Gym. You could not assume that all men are the same age. Thus, it would be an inaccurate measure to state that \\"the average age of men who attend Silver’s Gym is the same age as me.\\"
Averages are only one type of statistical measurements that may be of interest. For example, your company likes to gauge sales during a certain time of year and to keep costs low to a point that the business is making money. These various statistical measurements are important in the world of statistics because they help you make general conclusions about a given population or sample.
To assist in your analysis for Silver’s Gym, answer the following questions about the Body Fat Versus Weight data set:
Click here to download the Body Fat Weight data set.
·Calculate the mean, median, range, and standard deviation for the Body Fat (as Percent of body weight) Versus Body Weight data set (in pounds). Report your findings, and interpret the meanings of each measurement.
·The measures of central tendency are important in real-world situations.
o What is the importance of finding the mean/median? Why might you find this information useful?
·In some data sets, the mean is more important than the median. For example, you want to know your mean overall grade average because the median grade average would be meaningless. However, you might be interested in a median salary to see the middle value of where salaries fall. Explain which measure, the mean or the median, is more applicable for this data set.
·What is the importance of finding the range/standard deviation? Why might you find this information useful?
Compare the calculated mean values to median values to make a statement about the shape of distribution the way explained inside live chat power point presentation under Instructor Files.
- Compare the calculated mean of body fat for the sample versus 20% average body fat claimed by the manager of Silver Gym and make a statement (The manager's claim is indicated in Part 2).
– Provide research based and applied definitions of mean, median, range, standard deviation, and hypothesis testing along with reference citations.
Part II: Hypothesis Testing (Week 4 Revised)
Organizations sometimes want to go beyond describing the data and actually perform some type of inference on the data. Hypothesis testing is a statistical technique that is used to help make inferences about a population parameter. Hypothesis testing allows you to test whether a claim about a parameter is accurate or not.
Your boss makes the claim that the average body fat in men attending Silver’s Gym is 20%. You believe that the average body fat for men attending Silver’s Gym is not 20%. For claims such as this, you can set up a hypothesis test to reach one of two possible conclusions: either a decision cannot be made to disprove the body fat average of 20%, or there is enough evidence to say that the body fat average claim is inaccurate.
To assist in your analysis for Silver’s Gym, answer the following questions based on your boss’s claim that the mean body fat in men attending Silver’s Gym is 20%:
·First, construct the null and alternative hypothesis test based on the claim by your boss.
·Using an alpha level of 0.05, perform a hypothesis test, and report your findings. Be sure to discuss which test you will be using and the reason for selection.
·Based on your results, interpret the final decision to report to your boss.
Part III: Regression and Correlation
Based on what you have learned from your research on regression analysis and correlation, answer the following questions about the Body Fat Versus Body Weight data set (in pounds):
·When performing a regression analysis, it is important to first identify your independent/predictor variable versus your dependent/response variable, or simply put, your x versus y variables. How do you decide which variable is your predictor variable and which is your response variable?
·Based on the Body Fat Versus Weight data set, which variable is the predictor variable? Which variable is the response variable? Explain.
·Using Excel, calculate the slope and Y-intercept of the regression line; write the equation of the regression line; and construct a scatter plot of your data by including graph of the estimated regression line.
·Using the graph and intuition, determine whether there is a positive correlation, a negative correlation, or no correlation. How did you come to this conclusion?
·Calculate the correlation coefficient, r, and verify your conclusion with your scatter plot. What does the correlation coefficient determine?
·Add a regression line to your scatter plot, and obtain the regression equation.
o Does the line appear to be a good fit for the data? Why or why not?
o Regression equations help you make predictions. Using your regression equation, discuss what the slope means, and determine the predicted value of body weight (y) when body fat (x) equals 0. Interpret the meaning of this equation.
– Inside the EXCEL spreadsheet 3 for Part 3, use EXCEL functions and formulas the way shown during the live chat presentation to calculate the slope and intercept of the regression line followed by writing the equation of the regression line. Also, calculate the correlation coefficient.
Provide research based discussion about regression and correlation along with reference citations. Also, interpret the calculated values obtained inside the spreadsheet for slope, intercept, and correlation coefficient the way shown inside the power point presentation posted under Instructor Files.
NOTICE: Make sure you post and cite at least two references in your posting, with a reference obtained by using search engines and from outside course resources. Also, you are asked to cite the references for all statements you take from other sources and you use in your posting. Proper reference citation is a main research requirement in this course.
Part IV: Putting it Together
Your analysis is now complete, and you are ready to report your findings to your boss. In one paragraph, summarize your results by explaining your findings from the statistical measures, hypothesis test, and regression analysis of body fat and weight for the 252 men attending Silver’s Gym.
Instructor also requires including applied (non-mathematical) definitions of the related concepts, such as mean, standard deviation, hypotheses test, slope, intercept, and correlation for each part along with reference citations. Also, you are asked to interpret all calculated results obtained from EXCEL the way explained inside live chat Power Point presentation
I suggest you provide some reference citations from outside course related sources by using the search engines to obtain the highest possible grade.