+
Exploring Series Vol. 2, Chapter 8, A1 Statistical Functions

Exploring Series Vol. 2, Chapter 8, A1 Statistical Functions

Author: matthew stock
Description:

http://homework.plus/exploring-series-vol-2-chapter-8-a1-statistical-functions/

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:
Step

Instructions

Points Possible

1

Download and open the file namedexploring_e08_grader_a1, and then save the file asexploring_e08_grader_a1_LastFirst, replacing “LastFirst”with your name.

0

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.

5

3

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

5

4

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

5

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.

10

6

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

5

7

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

10

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.

10

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


(more)
See More
Try a College Course Free

Sophia’s self-paced online courses are a great way to save time and money as you earn credits eligible for transfer to over 2,000 colleges and universities.*

Begin Free Trial
No credit card required

25 Sophia partners guarantee credit transfer.

226 Institutions have accepted or given pre-approval for credit transfer.

* The American Council on Education's College Credit Recommendation Service (ACE Credit®) has evaluated and recommended college credit for 20 of Sophia’s online courses. More than 2,000 colleges and universities consider ACE CREDIT recommendations in determining the applicability to their course and degree programs.

Tutorial