Question: please provide excel steps how to do it. and this is a same question in the last pic there is data which is continuing from

 please provide excel steps how to do it. and this is

a same question in the last pic there is data which is

continuing from the last pic. ights (m) dummy You are an exobiologist

please provide excel steps how to do it. and this is a same question in the last pic there is data which is continuing from the last pic.

ights (m) dummy You are an exobiologist and are a critical part of the SpaceX mission to Mars. Mr. Elon Musk himself has given you the task of conducting research on the new plant specie 6090 You cannot take measure of all the alien plants so you decide to take measurements of a sample of these plants. The heights are shown to the left. 5790 Elon Musk believes these plants are on average taller than 500m. He will give you $1 million if you can prove him right. Show your reasoning. \begin{tabular}{|l} \hline 652 \\ \hline 768 \\ 717 \\ 485 \\ 730 \\ 553 \\ 795 \\ 598 \\ 465 \\ 576 \\ 740 \\ 800 \\ 788 \\ 662 \\ 744 \\ 517 \\ 474 \\ 620 \\ 770 \\ 679 \\ 505 \end{tabular} 2 Please review each problem and what is given to you and what the question is asking, and including the data provided in each tab. 3 Identify the type of hypotheis test needed to be done to solve the problem and go through the key steps for each hypothesis test. 4 There is a table that you will need to fill in to help you follow through all the steps

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 General Management Questions!