Investigating relationship between weight loss and workouts

Assignment Help Other Subject
Reference no: EM131262197

Statistical Functions

Project Description: You are the manager of a local gym and you will use excel to perform statistical analysis investigating the relationship between weight loss and workouts with a personal trainer.

Instructions: For the purpose of grading the project you are required to perform the following tasks:

Steps -

1. Download and open the file named exploring_e08_grader_a1, and then save the file as exploring_e08_grader_a1_LastFirst, replacing "LastFirst" with your name.

2. Enter a conditional function in cell L4 to calculate total members 25 years old or younger. Format the results with Number format and no decimal points.

3. Enter a similar function in cell L5 to calculate the total number of members over the age of 25.

4. Enter a conditional function in cell M4 to calculate the total membership fees paid by members 25 years old or younger.

5. Enter a similar function in cell M5 to calculate the total number of membership fees paid by members over the age of 25. Format the results in M4 and M5 with Accounting Number Format.

6. Enter a function in cell L9 that calculates the total number of members 25 years old or younger that lost more than 5 pounds.

7. Enter a similar function in cell L10 that calculates the total number of members over the age of 25 that lost more than 5 pounds.

8. Enter a function in cell H4 that calculates the rank of the weight loss in cell G4 against the range of individual weight lost in the data set.

9. Use the fill handle to copy the function down column H. Be sure to include the appropriate absolute or mixed cell references before copying the functions.

10. Enter a function in cell K13 to calculate the correlation of column G and I.

11. Format the results as Number format with three decimal positions.

12. Click the DATA tab and select Data Analysis. Select Descriptive Statistics and click OK. Complete the input criteria using the weight loss data in column G. Set the Output functions to display in cell K15 (Hint: be sure to output Summary Statistics).

13. Click the DATA tab and select Data Analysis. Select Histogram and click OK. Use the ages in column C as the input range. Use the age range K4:K5 as the bin range. Output the data to a new worksheet. Be sure to include a chart with the output.

14. Name the new worksheet Histogram. Move the Member Information worksheet so that it is first in the workbook.

15. Ensure that the worksheets are correctly named and placed in the following order in the workbook: Membership Information; Histogram. Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed.

Attachment:- Assignment.rar

Reference no: EM131262197

Questions Cloud

How contingency theory applicable to health organization : MHA601 Principles of Health Care Administration. In line with the implementation of the Affordable Care Act, how are the Contingency Theory and Resource Dependence Theory applicable to health care organizations
What is the role of self-interest in free market operations : What is the role of self-interest in free market operations (economic choice interactions)? Why engagement in self-interest may lead to better welfare for the society?
Female patient who sought to avoid having any more children : If it is determined that the sterilization procedure was done properly, how should the court rule?  - Why or why not?
Explore and review several tapes and various conversations : EXPLORE and review several tapes and various conversations. Was there inflection or difference in President Nixon's vocal patterns that would raise suspicion as an examiner? If so, what was it that you flagged?
Investigating relationship between weight loss and workouts : Project Description: You are the manager of a local gym and you will use excel to perform statistical analysis investigating the relationship between weight loss and workouts with a personal trainer
Complete the assignment about strategy diamond : Complete the assignment about Strategy Diamond. - Prepare a current event with one page connecting it to at least two facets of the Strategy Diamond.
How did the speaker use logos or argument in the speech : How did the speaker use "logos" or argument in the speech? Did they do so effectively? Examples? How effectively do you think the speaker used "language" in the speech? Was it a well-written speech? Examples?
How can boston do political work to help remedy this : Boston is a city of constant change with significant potential to do "political work". What do you see as the most significant problems facing our society, and how can Boston do political work to help remedy this? Draw on examples from readings of..
How might you communicate differently in the future : How was the communication effective? How could it have been more effective? How might you communicate differently in the future?

Reviews

Write a Review

Other Subject Questions & Answers

  Cross-cultural opportunities and conflicts in canada

Short Paper on Cross-cultural Opportunities and Conflicts in Canada.

  Sociology theory questions

Sociology are very fundamental in nature. Role strain and role constraint speak about the duties and responsibilities of the roles of people in society or in a group. A short theory about Darwin and Moths is also answered.

  A book review on unfaithful angels

This review will help the reader understand the social work profession through different concepts giving the glimpse of why the social work profession might have drifted away from its original purpose of serving the poor.

  Disorder paper: schizophrenia

Schizophrenia does not really have just one single cause. It is a possibility that this disorder could be inherited but not all doctors are sure.

  Individual assignment: two models handout and rubric

Individual Assignment : Two Models Handout and Rubric,    This paper will allow you to understand and evaluate two vastly different organizational models and to effectively communicate their differences.

  Developing strategic intent for toyota

The following report includes the description about the organization, its strategies, industry analysis in which it operates and its position in the industry.

  Gasoline powered passenger vehicles

In this study, we examine how gasoline price volatility and income of the consumers impacts consumer's demand for gasoline.

  An aspect of poverty in canada

Economics thesis undergrad 4th year paper to write. it should be about 22 pages in length, literature review, economic analysis and then data or cost benefit analysis.

  Ngn customer satisfaction qos indicator for 3g services

The paper aims to highlight the global trends in countries and regions where 3G has already been introduced and propose an implementation plan to the telecom operators of developing countries.

  Prepare a power point presentation

Prepare the power point presentation for the case: Santa Fe Independent School District

  Information literacy is important in this environment

Information literacy is critically important in this contemporary environment

  Associative property of multiplication

Write a definition for associative property of multiplication.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd