Question

#### All Subjects Mathematics General Mathematics

Offered Price \$15.00

# Math 301 Statics or Neal

Question # 00001128
Subject: Mathematics
Due on: 09/16/2013
Posted On: 09/15/2013 05:59 PM

Rating:
4.1/5
Posted By
Questions:
24
Tutorials:
0
Feedback Score:

Question
ok here is the chart that you have to use can you let me know if you got it correctly. Also to here are the guidelines to follow.
Part I: Statistical Measurements --- Here is how to obtain the mean or algebraic average of body weight of 252 Silver Gym members. Notice column "A" only shows the members ID numbers and it cannot be used for calculations. Column "B" of data table represents body fat of members in percent while Column "C" of data table represents body weight of members in pounds. Also we notice that both columns B and C data values begin on row 2 and ends on Row 253. Notice that Row 1 is used to show the headings or titles of each column. So for all calculations we need to enter the following Excel format inside the Excel formula window to represent the entire data for body fat and body weight.
Means Values------ 1. Place the cursor in empty cell to the right side of the data table (in similar cell locations shown inside instructors spreadsheet).
2. Open "Formula" tab located at the top of the spreadsheet.
3. Open the tab appearing as more function with orange color background by placing the cursor on this tab by holding down the left click of mouse to open "more function" tab.
4. Open "Statistical " from the list that appears at this time.
5. From the vertical menu that opens at this time (in alphabetical order) select Average tab in order to find the mean or average of the body fat. Open the Average tab.
6. From the window that pops up at this time you will see two small rectangular windows at the top. Select the small window at the top. Place the cursor inside this window and exactly type in: B2:B253.
7.Ignore the second small window, and open "OK" tab.
8. Now, move the cursor to inside spreadsheet inside a remote and blank cell
9. At this time you should be able the calculated value for mean of body fat inside the cell you initially selected.
In order to obtain the calculated value for mean of the body weight follow exactly the steps stated above by typing in the following inside the opened window in step 6:
C2:C253
MEDIAN
In order to find the median of the body fat and body weight follow the 9 steps stated above except in step 5 select the following function tab from the appearing vertical menu.
MEDIAN
Once again use B2:B253 for the median of body fat and C2:C253 for median of body weight of the Gym members.
Standard Deviation--- In order to find the standard deviation of the body fat and body weight follow the 9 steps stated above except in Step 5 select the following function tab(not other similar tabs) from the appearing vertical menu:
STDEV. S
Once again use B2:B253 for standard deviation of body fat and repeat this process with C2:C253 for standard deviation of body weight of the Gym members.
RANGE
Notice that there is no quick formula available inside Excel statistical function menu for range. Range is the difference between the greatest and smallest value of the data set. Hence we must subtract the smallest value from the largest value in each column B and C of the data table to find the range for body fat and body weight, respectively. The exact formula to be created is shown below.
For range of body weight
MAX(B2:B253)
For range of body weight
MAX (C2:C253) - MIN (C2:C253)
Notice in case you type in these formulas inside the function window at the top you might receive an error message inside the selected cell location. In order to avoid this issue I suggest you follow these simple guidelines:
1. For the range of body fat locate the cursor on an empty cell location.
2. Manually type in the exact following statement (must include equal signs first) = MAX (B2:B253)
3. Move the cursor to a remote and empty cell location inside your spreadsheet and place it inside the empty cell for a moment by pressing on left click of your mouse in order to avoid error message by Excel.
4. At this time you should be able to see the calculated range of body fat for your data table in percent.
For range of body weight ----
Follow the steps stated above exactly except in step 2 you need to manually type in = MAX (C2:C253) - MIN (C2:C253)
This will provide you with the range of body weight of Gym members in pounds for your data table inside your spreadsheet.
Part 2: Hypothesis Testing
You will use the spreadsheet, below Part 1, to perform the P- Value to Part 2: Hypothesis testing about the claim or hypothesis manager.
P-Value Calculations
Population Mean of Body Fat
1. Place the cursor inside cell location H20 and manually type in "20"for mean of body fat population. Make sure you move the cursor after typing to a remote area and place it in a blank cell location and left click there in order to avoid an error message.
Standard deviation of Body Fat
2. Place the cursor inside cell H22. Then find the standard deviation of body fat the way explained in part 1 inside spreadsheet 1.
P-Value Calculation
3. Place the cursor inside cell location H24. Then open "Formulas tab at the top of spreadsheet. Then open "more functions" tab. Then, open statistical tab from the appearing list. Then from the vertical menu that pops up on the right side select Z-Test function at the bottom of the vertical menu. A window pops up with three small windows.
4. Type in "B2:B253" inside the top window to represent the array of data for body fat.
5. Place the cursor inside the middle window and type in "20". This represents the population mean of body fat of 20.
6. Place the cursor inside the lower or third window and type in "H22". This represents the standard deviation.
7. Now open "OK" tab at the bottom of the large window.
8. You should be able to see the cumulative probability of error inside cell location H24.
9. Place the cursor in cell location "H27" and manually type in = 1 - H24. This will find the complement of the probability found for F7 location.
10. Place the cursor in cell "H29" and manually type in "= 2*H27". This will provide the P-value for two tails of normal distribution.
11. You need to use this P-value (in H29 cell location) inside the word document to perform the hypothesis test in part 2 the way explained inside power point presentation.
This will complete all calculations for two parts of this phase. In part 2 inside your word document you need to show the required five steps to perform the hypothesis two tailed test as we discussed in the live chats. Please place all of your discussions and responses inside your word document and not inside the spreadsheet.
Cities, References and APA format.

Attachments
Tutorials for this Question
Available for
\$20.00

#### Math 301 Stats assignment

Tutorial # 00001079
Posted On: 09/16/2013 04:11 PM
Posted By:
neil2103
Questions:
9603
Tutorials:
14239
Feedback Score:
Tutorial Preview ……
Attachments
BodyFat_Weight_data1.xls (35.5 KB)
hase_4_professors.xlsx (17.63 KB)
Preview: Probability(Calculated)P-value xx Righ xxxxxxxxxxxx for Two xxxxxxxxx table and xxx the xxxxxxxxxxxxxxxxxxx xxxxxxxx as xxxxxxxxxx to obtain xxx post the xxxxxxxxxxxxxxxx that xx xxxxxxxx to xxxxxxxxxxxx for your xxxxx posting Cyrus xxxxxxxxxxxxx do xxx xxx the xxxxxxxxxxxxxx Task List xxxxxxxxxxx with.....
mat_301.docx (19.64 KB)
Preview: min xxxxx of x particular data xxx It denotes xxx range xxxxxx xxxxx the xxxxxx are spread xxx measures of xxxxxxx tendency xxxx xxxxx situations xxxx is the xxxxxxxxxx of finding xxx mean/median? xxx xxxxx you xxxx this information xxxxxxx The mean xxx median xxx xxxxxxxxx because xxxx are two xxxx of showing xxx typical xxxxxxxx xxxxx  The xxxx is important xxxx there are xx significant xxxxxxxxxx xx the xxxx   Mean xxxxxxxxx shows the xxxxxxx of xxx xxxxxx So xx lots of xxxx are high xxxxxx and xxxx xxx low xxxxxx then mean xxxx tend to xxxx towards xxx xxxxxx values xxx that can xxxx us a xxxxx picture xxx xxxxxx is x better measure xxxx the data xx skewed xx xxxxx are x lot of xxxxxxxxxx  It gives xx exactly xxx xxxxxx value xxxx all the xxxx are arranged xx ascending xxxxx xxxxxxx giving xx a good xxxxxxx of data xxx variations x xx some xxxx sets, the xxxx is more xxxxxxxxx than xxx xxxxxx For xxxxxxx you want xx know your xxxx overall xxxxx xxxxxxx would xx meaningless However, xxx might be xxxxxxxxxx in x xxxxxx salary xx see the xxxxxx value of xxxxx salaries xxxx xxxxxxx which xxxxxxx the mean xx the median xx more xxxxxxxxxx xxx this xxxx set.....
* - Additional Paypal / Transaction Handling Fee (3.9% of Tutorial price + \$0.30) applicable
Available for
\$40.00

#### due paymet due paymet

Tutorial # 00001291
Posted On: 09/20/2013 01:05 PM
Posted By:
neil2103
Questions:
9603
Tutorials:
14239
Feedback Score:
Tutorial Preview …paymetdue…
* - Additional Paypal / Transaction Handling Fee (3.9% of Tutorial price + \$0.30) applicable