Question: Please help: EXCEL QUESTION It was believed that the mean age of US presidents when taking power is 55. However, a reporter believes it has

Please help:

EXCEL QUESTION It was believed that the mean age of US presidents when taking power is 55. However, a reporter believes it has increased since 76-year-old Joe Biden was elected. A random sample of 36 presidents' ages were listed below. Test if the reporter's claim is true at a 10% significance level. Use Excel formulas/functions to calculate the test statistic and make your conclusion using either the critical value or p-value approach. [10 marks] US President Age when taking power Washington 57 J. Adams 61 Jefferson 57 Madison 57 Monroe 58 J. Q. Adams 57 Jackson 61 Van Buren 54 Harrison 68 Tyler 61 Polk 49 Taylor 64 Fillmore 50 Pierce 48 Buchanan 65 Hayes 54 B. Harrison 55Mckinley 54 T. Roosevelt 42 Wilson 56 Harding 55 Hoover 54 Truman 60 Eisenhower 62 Kennedy 43 Johnson 55 Nixon 56 Ford 61 Carter 52 Reagan 69 G. H. Bush 64 Clinton 46 G. W. Bush 54 Obama 47 Trump 70 Biden 76

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

Please help me use this book for citation for my essay Read the book Boss - 2014 "Moral Reasoning" Ethics for Life- A Text with Readings Ch2 CHAPTER 2 .first importance. Mo,af ReaEoning In a...

please read case and answer question below. case 14: harley-davidson: strategic competitiveness that spans decad guriqbal chee joel cunningh pallavi dalipart john klosterma brian ra texas a&m...

I have asked three questions with my textbook chapter in which they come from. it would be greatly appreciated if you could help me answer these three questions. Thanks so much. :) 1. What is the...

Hello can you please help with this case study, that's an exercice given by the teacher in order for us to get ready for the mid-term, he said he is going to give something like that, so we should...

The following case study is connected to the questions below: Please assist with answering the following questions in a synopsis format related to case study: Brief Overview of Client DSM Diagnosis...

topic: importance of workalike balance for women as a leader in healthcare. 1. The purpose of the research; 2. Research question/s; 3. Findings and relevant data; 4. Any recommendations and; 5. The...

please can you please help me with this case in order for me to get prepared for my midterm. this is not a homework, its a case given by the professor for us to get ready for the upcoming exam...

Opening Statement for Defense The 1948 U.S. Presidential election was a hard fight for Harry Truman. No one thought he had a shot and the folks at the Chicago Daily Tribune didn't think so either. At...

will you please answer my questions i just posted 6. Audit Considerations: a. What material types of transactions and transaction cycles are involved? b. What are the high-risk areas? c. What are the...

The following transactions occurred at forever green lawn service identify which account would be debited and credited to record each transaction Write the identitying letters in the proper colunmns...

In a Gallup poll of 1004 adults, 93% indicated that restaurants and bars should refuse service to patrons who have had too much to drink. If you plan to conduct a new poll to confirm that the...

1. Which of the following fractions is obtained by the distillation of petroleum residue under reduced pressure? (a) bitumen (b) kerosene (c) naphtha (d) refinery gases

Q26 Question 26 3 pts You and your spouse currently make $100,000 together. You have looked at your budget and think you could live on $80,000 in retirement because your home will be paid off and you...

a lack of management responsibility concerning ecological issues and the utilization of scarce resources.

a neglect of quality in relationship to international competitors;

full employment policies, and therefore lack of concern with negative appraisal, as salaries varied very little and there was no danger of unemployment;