Username
Forgot Password?
Password
Create Account
Search
Search by Tutorial / Question #
Username
Password
Forgot Password?
Create Account
Ask a Question
Blog
FAQ
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
donanorman
Questions:
24
Tutorials:
0
Feedback Score:
Not rated yet!
Purchase it
Report this Question as Inappropriate
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
.
First download the spreadsheet with data related to body fat (in pounds) of Silver Gym members
.
Then, download the sample of professor's spreadsheet on how to complete the task of the instructor's spreadsheet with similar data and calculated values used
.
The location of data table inside instructor's spreadsheet is excel
.
Task list with body fat weight data for Silver Gym create a second spreadsheet within the same excel posting for Phase 4 IP for hypothesis testing
.
Part 1 will be used for statistical measurements and the second part will be used for calculations of P-value for hypothesis testing
.
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
Copy_of_BodyFat_Weight_data1.xls
(39.5 KB)
Raw Preview for Copy_of_BodyFat_Weight_data1.xls
Phase_4_professors_copy_of_spreadsheet^.xlsx
(18.11 KB)
Raw Preview for Phase_4_professors_copy_of_spreadsheet^.xlsx
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:
97% (13620 ratings)
Report this Tutorial as Inappropriate
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.....
Purchase this Tutorial @ $20.00
^{*}
* - 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:
97% (13620 ratings)
Report this Tutorial as Inappropriate
Tutorial Preview
…paymetdue…
Purchase this Tutorial @ $40.00
^{*}
* - Additional Paypal / Transaction Handling Fee (3.9% of Tutorial price + $0.30) applicable
List of Main Subjects
Accounting
Anthropology
Architecture
Art
Asian Studies
Astronomy
Biology
Business
Chemistry
Communications
Computer Science
Economics
Education
Engineering
English
Finance
Foreign Languages
Gender Studies
General Questions
Geography
Geology
Health Care
History
Kindergarten
Law
Linguistics
Literary Studies
Marketing
Mathematics
Music
Nursing
Performing Arts
Philosophy
Physics
Political Science
Psychology
Religious Studies
Sociology
Statistics
Urban Planning and Policy
View all subjects...
×
Don't found the question and answer that you searching for ?
Don't worry
Ask Mike.
You will get the response within
1 hour
Institution:
Course ID:
Email address:
Question:
Time:
Select Time
With in 1 hour
With in 6 hour
With in 12 hour
With in 24 hour
Attach File:
Ask Mike
Quick Search
(please type in the exact tutorial number or question number to search)
Search by
Question #
GO
Or,
Tutorial #
GO
Loading...