I need help with this assignment. Thanks. It's from my CIS2000 Class, dealing with Excel.

Office 2013 - myitlab:grader - Instructions Exploring Series Vol. 2, Chapter 8, A1 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 Points Possible Instructions 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. 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 more than 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 more than 5 pounds. 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 10 Enter a function in cell K13 to calculate the correlation of column G and I. Updated: 07/17/2013 1 5 E_CH08_EXPV2_A1_Instructions.docx Office 2013 - myitlab:grader - Instructions Step Exploring Series Vol. 2, Chapter 8, A1 Points Possible Instructions 11 Format the results as Number format with three decimal positions. 5 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). 10 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. 15 14 Name the new worksheet Histogram. Move the Member Information worksheet so that it is first in the workbook. 5 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. 0 Total Points Updated: 07/17/2013 2 100 E_CH08_EXPV2_A1_Instructions.docx Member Analysis Last Name Age Total Fees Start Weight Current Weight Weight Loss Rank Hernandez 65 $ 35.63 197 180 17 Huang 55 $ 363.75 127 120.65 6.35 Jayaraman 35 $ 245.00 266 252.7 13.3 Kang 29 $ 322.50 157 149.15 7.85 Wilson 63 $ 202.50 297 225 72 Huang 30 $ 405.75 270 240 30 Rivera 57 $ 225.25 177 168.15 8.85 Shimizu 27 $ 357.10 128 121.6 6.4 Lim 24 $ 380.63 152 152 0 Gonzalez 30 $ 93.75 211 200.45 10.55 Evans 21 $ 238.13 240 200 40 Hyat 50 $ 275.35 246 233.7 12.3 Carter 59 $ 265.25 180 171 9 Jeong 37 $ 84.38 273 259.35 13.65 Diaz 55 $ 345.00 276 262.2 13.8 Matsumoto 28 $ 125.00 253 240.35 12.65 Rodriguez 49 $ 324.38 151 143.45 7.55 Yoshida 39 $ 341.25 198 188.1 9.9 Flores 60 $ 310.00 239 195 44 Hamieh 29 $ 324.38 123 116.85 6.15 Azzi 61 $ 350.00 195 185.25 9.75 Hassan 65 $ 275.50 238 226.1 11.9 Hussein 20 $ 238.13 136 129.2 6.8 Mistry 25 $ 792.50 310 294.5 15.5 Yoshida 37 $ 635.00 170 161.5 8.5 Yoo 47 $ 775.00 272 258.4 13.6 Lim 65 $ 540.00 225 213.75 11.25 Gonzalez 44 $ 211.88 232 175 57 Sato 38 $ 365.63 179 160 19 Park 31 $ 852.50 110 110 0 Hyat 30 $ 378.75 197 187.15 9.85 Patil 23 $ 887.50 169 160.55 8.45 Lim 29 $ 234.38 174 165.3 8.7 Hong 38 $ 555.00 153 153 0 Sanchez 58 $ 213.75 250 237.5 12.5 Lim 38 $ 135.00 129 122.55 6.45 Guo 43 $ 175.00 203 192.85 10.15 Abboud 64 $ 215.00 211 200.45 10.55 Ma 33 $ 86.25 298 283.1 14.9 Bettar 63 $ 112.50 230 218.5 11.5 Xu 63 $ 112.50 140 133 7 Lee 59 $ 341.25 295 280.25 14.75 Azizi 22 $ 157.00 176 167.2 8.8 Gao 23 $ 264.38 125 118.75 6.25 Hamieh 22 $ 311.25 115 109.25 5.75 Lee Watanabe Gonzalez Yoon Huang 55 51 48 60 26 $ $ $ $ $ 168.75 48.75 225.00 200.00 175.00 302 206 256 268 264 286.9 195.7 210 205 201 15.1 10.3 46 63 63 Trainer Visits 12 8 2 6 1 5 15 5 9 8 14 7 3 3 14 3 10 3 15 13 3 7 3 3 4 12 14 15 13 9 7 10 8 5 4 11 5 13 13 7 8 6 14 1 4 Age Groups Count 25 50 Age Groups > 5lbs lost 25 50 Correlation Total Fees 2 1 11 2 8