A recent graduate moving to a new job collected a sample of the monthly rent (in...

A recent graduate moving to a new job collected a sample of the monthly rent (in dollars) and the size (in square feet) of 3-bedroom apartments in one area of a city. Use Excel to find the best fit linear regression equation, where size of the apartment is the explanatory variable. Round the slope and intercept to two decimal places.

Size   Rent
961   "909 "
949   1048
924   "841 "
920   "704 "
902   1131
893   "867 "
888   2532
886   "800 "
876   1030
875   "758 "
864   "930 "
860   1227
851   "931 "
848   1820
845   "711 "
841   1040
838   1373
829   1158
827   3111
815   "733 "
802   "870 "
801   1464
792   "839 "
790   1387
779   2050
748   3275
741   1996
730   1708
727   4031
711   1756

Solutions

Expert Solution

Calculations are

orchestra answered 10 months ago

Next > < Previous

Related Solutions

A sample of 25 values for monthly rent of two-bedroom apartments was selected from a recent...

A sample of 25 values for monthly rent of two-bedroom apartments was selected from a recent edition of the Gainsville Sun. The distribution of the 25 values is symmetric, with no outliers. The mean of this sample was $575, and you may estimate that the population standard deviation was $165. a. A group of students think the true mean rent for this type of apartment is over $650. Is there statistical evidence in the data to reject their claim? b....

Jorge Jones, a recent management graduate has a new job as a shelf stocker at the...

Jorge Jones, a recent management graduate has a new job as a shelf stocker at the local Shop and Stop (bad job market). In order to maintain some of the knowledge he gained in college, Jorge wants to apply regression analysis to predict weekly sales on the cereal aisle. He believes there would be a relationship between the shelf space that a particular product takes up and the sales of that product. Jorge has gathered the following data: Shelf Space...

A recent college graduate buys a new car by borrowing $24,000 at 7.2%, compounded monthly, for...

A recent college graduate buys a new car by borrowing $24,000 at 7.2%, compounded monthly, for 3 years. She decides to pay $764 instead of the monthly payment required by the loan. (a) What is the monthly payment required by the loan? (Round your answer to the nearest cent.) (a) What is the monthly payment required by the loan? (Round your answer to the nearest cent.) - How much extra did she pay per month? (Round your answer to the...

A recent college graduate buys a new car by borrowing $22,000 at 8.4%, compounded monthly, for...

A recent college graduate buys a new car by borrowing $22,000 at 8.4%, compounded monthly, for 4 years. She decides to pay $552 instead of the monthly payment required by the loan. (a) What is the monthly payment required by the loan? (Round your answer to the nearest cent.) $ How much extra did she pay per month? (Round your answer to the nearest cent.) $ (b) How many $552 payments will she make to pay off the loan? (Round...

A recent college graduate has taken a new job at Work LLC, and since the company...

A recent college graduate has taken a new job at Work LLC, and since the company does not offer a traditional pension plan, she plans to take advantage of a tax-free investment account backed by a reputable financial institution that offers a guaranteed 8% annual return for as long as she lives. The graduate plans on working for 45 years before retiring and will save a fixed amount each year until retirement, starting at the end of this year and...

Final Scenario You're a recent graduate of Champlain College and landed a great job in New...

Final Scenario You're a recent graduate of Champlain College and landed a great job in New York as a junior financial analyst for Chuck Schwable, a leading investment firm whose name bears no resemblance to a well known investment firm. Schwable has recently been hired by Giggle, a leading tech giant, to provide some capital budgeting recommendations for a major building project in downtown Manhattan. This is it...it's your big chance to make a great first impression and show off...

A recent college graduate has taken a new job at Work LLC, and since the company...

This sample data was collected to study the relationship between the rent charged with the size...

This sample data was collected to study the relationship between the rent charged with the size of a dwelling. Identify the dependent variable and independent variable. Do they have a cause and effect relationship? Explain. Run Regression on this data. Make sure to check the boxes for charts, normal distribution, residual charts, etc. Write the null and alternate hypotheses to test if the linear relationship (slope) is significant or not. Conduct F test to determine if you are going to...

Monthly rent paid by undergraduates and graduate students. Undergraduate Student Rents (n = 10) 810 770...

Monthly rent paid by undergraduates and graduate students. Undergraduate Student Rents (n = 10) 810 770 870 710 730 830 820 660 980 700 Graduate Student Rents (n = 12) 1,150 910 920 860 780 910 740 820 940 920 830 880 (a) Construct a 90 percent confidence interval for the difference of mean monthly rent paid by undergraduates and graduate students, using the assumption of unequal variances with Welch's formula for d.f. (Do not round the intermediate calculations. Round...

Angle, age 24 and single, is a recent college graduate. They have just accepted a job...

Angle, age 24 and single, is a recent college graduate. They have just accepted a job offer with Financial Planning Pals, LLC, as a financial planner making $100,000/ yr. Angle has some student debt and lives in an apartment without any roommates. They have $0 savings currently. Additionally, Financial Planning Pals, LLC is a cheap employer and they do not offer any type of Qualified Retirement Plan. Angle is confused about how to pay down their student loan debt, establishing...

Subjects