### Free Educational Resources

• > Exploring Series Vol. 2, Chapter 8, A1 Statisti...
+

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

##### Rating:
(1)
• (0)
• (0)
• (0)
• (1)
• (0)
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

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)
##### 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.*

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 21 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