IMG_0113

.png

School

American Military University *

*We aren’t endorsed by this school

Course

302

Subject

Statistics

Date

Apr 3, 2024

Type

png

Pages

1

Uploaded by AdmiralWildcatPerson1030

Report
8:45AM Wed Mar 20 Xy w @ 9%94% =) < Back Week 7 Test { Back © O Question 11 1/ 1 point Data for a sample of 30 apartments in a particular neighborhood are provided in the worksheet. You want to see if there is a direct relationship between Size of the Apartment and Rent. What is the Significance F or p-value of the linear regression model? Place your answer in the blank. Round to 4 decimal places. When entering your answer do not use any labels or symbols. Simply provide the numerical value. For example, 123 would be a legitimate entry. Make sure you put the O in front of the decimal. Please see Attached Excel for Data. Apartments data Answer: 0.0000 v ¥ Hide question 11 feedback You will run a Simple Linear Regression Analysis in Excel using the Data Analysis ToolPak. Data -> Data Analysis -> Scroll to Regression Highlight Rent for the Y Input: Highlight Size for the X Input: Make sure you click on Labels and Click OK If done correctly then Significance
Discover more documents: Sign up today!
Unlock a world of knowledge! Explore tailored content for a richer learning experience. Here's what you'll get:
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help