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 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
Get step-by-step solutions from verified subject matter experts
