Question
Please the instructor said we need to submit this in excel please . Someone did it it for me without excel and told me to put it in excel but I can’t figure it out please I need this in Excel and all the calculation need to use excel formulas please. I attached what has been done but I need it Excel please using excel formulas to do the calculations. Thank you so much
According to the National Center for Health Statistics, the mean height of an American male is 69.3 inches and the mean height of an American female is 63.8 inches. The standard deviation for both genders is 2.7 inches. min According to Chebyshevs Theorem 75% of the data for your gender lies between what two heights? . If height is assumed to be normal, what percentage of the data lies between those same two heights?
media%2F555%2F5554ade4-cbf6-4912-bb4b-d8
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Please find below the Excel sheet -

Paste Format PainterA Conditional Font Number A9 1 Solution A 2 Lower limit - mean -2sd 3 Upper limit mean +2sd 4 5 According to chebsheves 75% male height lies in between 747-639 6 According to chebsheves 75% female height lies in between 69.2-58.49 7 8 Male Female 69.3 63.8 2.7 63.9 58.4 74.7 69.2 9 Mearn 10 SD 2.7 11 Lower limit 12 Upper limit 13 14 15 Solution B K4 Sheeti Sheet2 Sheet3 Edit

Add a comment
Know the answer?
Add Answer to:
Please the instructor said we need to submit this in excel please . Someone did it...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Could someone please help me solve this. The correct answers are shown. I keep getting this...

    Could someone please help me solve this. The correct answers are shown. I keep getting this question wrong and cannot wrap my head around how to do it. Thank you! For a? two-tailed hypothesis test at the significance level ??, the null hypothesis H0?: ?=?0 will be rejected in favor of the alternative hypothesis Ha?: ???0 if and only if ?0 lies outside the (1??)-level confidence interval for ?. Illustrate the preceding relationship by obtaining the appropriate? one-mean z-interval for...

  • I need answer for these in excel format ... please by using excel formulas for example...

    I need answer for these in excel format ... please by using excel formulas for example =NORM.dis() ... as soon as possible please! And thankyou! Fonmattin Undo Cipboard Font A manulacturer produces ight buibs that have a mean ide of at least 600 hours when the production process is working properly. Based on past experience, the population standard deviation is 50 hours and the ight bulb ide is normally distributed The operations manager selects a random sample df5o light bulbs,...

  • Really short question! Please help me to solve, thank you! Yet, the data set is too...

    Really short question! Please help me to solve, thank you! Yet, the data set is too big (n=8000) as I can’t show all of them. Hope that the information of the second picture would be helpful. (30%)Q4 (EM algorithm): The heights of n 8000 students are drawn from a school. Assume the height largely depends on the gender. We denote the height of student i by Yi, and the gender of student i by Z..(Y; : 1 i n) are...

  • please show work in excel Question 5 25 pts Answer this question on Recruits sheet. AU.S....

    please show work in excel Question 5 25 pts Answer this question on Recruits sheet. AU.S. Navy recruiting center knows from past experience that the heights of its recruits have traditionally been normally distributed with mean 69 inches. The recruiting center wants to test the claim that the average height of this year's recruits is greater than 69 inches. To do this, recruiting personnel take a random sample of 64 recruits from this year and record their heights. The data...

  • I need answers for these as soon as possible... but in excel format by using formulas...

    I need answers for these as soon as possible... but in excel format by using formulas in MS excel ... please! And thankyou! Fonmattin Undo Cipboard Font A manulacturer produces ight buibs that have a mean ide of at least 600 hours when the production process is working properly. Based on past experience, the population standard deviation is 50 hours and the ight bulb ide is normally distributed The operations manager selects a random sample df5o light bulbs, and the...

  • I need someone to do this for me please. The third photo is my professor's brief...

    I need someone to do this for me please. The third photo is my professor's brief example. PC/SPREADSHEET PROBLEM #1 --AGING OF RECEIVABLES - 25 POINTS DUE-Monday Tuesday, NOVEMBER 4/5. 2019 American Box Company is negotiating a working capital line of credit with its finance company/bank. The finance company/bank told American Box's CFO (Chief Financial Ollicer) that the line of credit request would require an aging of receivables schedule. Because you will soon become a freshly-minted Accounting Principles I graduate,...

  • Please show all your work. I need step by step. How did you solve? Please help...

    Please show all your work. I need step by step. How did you solve? Please help me both part or both question. Please help me with all question. Will give you thumbs up. 3. According to government data, 25% of employed women have never been married. If 20 employed women are selected at random, what is the probability that two or fewer of them have never been married? (Note: set up a numerical expression only, but you do not have...

  • I need someone to do this for me please. PC/SPREADSHEET PROBLEM #1 --AGING OF RECEIVABLES - 25 POINTS DUE-Monday Tu...

    I need someone to do this for me please. PC/SPREADSHEET PROBLEM #1 --AGING OF RECEIVABLES - 25 POINTS DUE-Monday Tuesday, NOVEMBER 4/5, 2019 American Box Company is negotiating a working capital line of credit with its finance company/bank. The finance company/bank told American Box's CFO (Chief Financial Ollicer) that the line of credit request would require an aging of receivables schedule. Because you will soon become a freshly-minted Accounting Principles I graduate, the CFO has delegated the assignment to you....

  • I need someone to help answer table 1 only mass, volume, y density and table 2...

    I need someone to help answer table 1 only mass, volume, y density and table 2 with a graph each table. please read the procesures, thank you Experiment 2 Graphing and Measurements Graphs summarize numerical data efficiently and are usually casier to understand and interpret than columns of numbers. In this experiment, you will collect data and construct a graph that makes an effective visual presentation. Materials: Equipment metric ruler Chemical a kit with 5 pieces Procedure: Part I: Measurements...

  • i need help on finding the last information im having trouble with creating a graph from the excel spreed sheet if some one could guide me through the steps, please. What should I place in exc...

    i need help on finding the last information im having trouble with creating a graph from the excel spreed sheet if some one could guide me through the steps, please. What should I place in excel to create the graph when I placed the water bath and temp as well as HCI added it gives me seprate lines. Thanks in advance. C. Data Analysis pse of all buret washin You will the titrant heed to provide your data to your...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT