Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Hello, can you show me how to do this problem using excel please and Question D) also got cut off so the options are there

image text in transcribed

Hello, can you show me how to do this problem using excel please and Question D) also got cut off so the options are there is no evidence that the population mean real estate exam score is not 71(that is 71, is plausible value for the population mean real estate exam score. Or there is enough evidence that the population mean real estate exam score is 71 or there is enough evidence out the population mean real estate exam score is not 71.

image text in transcribedimage text in transcribed
From past experience, a workshop instructor believes that the average score on a real estate exam is 71. The following data represent a random sample of 19 student's exam scores. Click this button to reveal the data Score 81 70 73 71 Click Download CSV to download csy file of data or copy/paste the data into Excel. When you paste, use Paste Special and then select Unicode Text. After downloading the file, you must save it as an Excel Workbook. Otherwise, your tables and graphs will not be saved properly. As you work in Excel be sure to save all your work and clearly label your results. If you have a Mac computer, then please watch How to Add the Data Analysis ToolPak in Excel on Mac 2018. . If you have a windows operating system, please watch How to Add the Data Analysis ToolPak in Excel 2016 for Windows. a. Select the correct answer for null and alternative hypotheses for this test. Ho:p = 71 Ho: # = 71 Ho : P = 71 Ha:p > 71 Ha:p # 71 Ha : 71 Ha :p 71 Ha:p # 71 Ha : p 71 Ha :P

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

College Geometry Using The Geometer's Sketchpad

Authors: Barbara E Reynolds, William E Fenton

1st Edition

1118213408, 9781118213407

More Books

Students also viewed these Mathematics questions

Question

Where do you see the organization in 5/10 years?

Answered: 1 week ago