Jasmine owns 12 apartment buildings in a college town, which it rents exclusively to students. Each apartment building contains 120 rental units, but the owner is having cash flow problems due to an average vacancy rate of nearly 50 percent. The apartments in each building have comparable floor plans, but some buildings are closer to campus than others. Jasmine’s accumulated data from last year on the number of apartments rented, the rental price (in dollars), and the amount spent on advertising (in hundreds of dollars) at each of the 12 apartments are available below. These data, along with the distance (in miles) from each apartment building to campus, are presented below. Jasmine is looking for an expert advice on the available data to inform administrative and business policy. By applying the knowledge gain from PADM 563 class, kindly help her regress the quantity demanded of her apartments on price, advertising, and distance by using either Excel or SPSS or Gretl. A.    Based on the regression output estimate the associated demand function for Jasmine’s rental units?  B.    If Jasmine raised rents at one complex by $100, what would you expect to happen to the number of units rented?   C.    If Jasmine raised rents at an average apartment building, what would happen to her total revenues?  D.    What inferences should be drawn from this data analysis to assist Jasmine to make a rational managerial decision?

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter10: Statistics
Section10.5: Comparing Sets Of Data
Problem 24HP
icon
Related questions
Topic Video
Question

Jasmine owns 12 apartment buildings in a college town, which it rents exclusively to students. Each apartment building contains 120 rental units, but the owner is having cash flow problems due to an average vacancy rate of nearly 50 percent. The apartments in each building have comparable floor plans, but some buildings are closer to campus than others. Jasmine’s accumulated data from last year on the number of apartments rented, the rental price (in dollars), and the amount spent on advertising (in hundreds of dollars) at each of the 12 apartments are available below. These data, along with the distance (in miles) from each apartment building to campus, are presented below. Jasmine is looking for an expert advice on the available data to inform administrative and business policy. By applying the knowledge gain from PADM 563 class, kindly help her regress the quantity demanded of her apartments on price, advertising, and distance by using either Excel or SPSS or Gretl.

A.    Based on the regression output estimate the associated demand function for Jasmine’s rental units? 

B.    If Jasmine raised rents at one complex by $100, what would you expect to happen to the number of units rented?  

C.    If Jasmine raised rents at an average apartment building, what would happen to her total revenues? 

D.    What inferences should be drawn from this data analysis to assist Jasmine to make a rational managerial decision?

Observation or
Quantity Price Advertising Distance
(Number of
Apartments)
1
28
250
11
12
2
70
400 24
3
43
450 15
5
4
32
550 31
8
5
42
576 34
4
6.
73
376 23
3
7
66
375 13
5
8
49
450 24
7
9
70
400 22
4
10
60
375 10
5
11
70
400 22
4
12
60
375 10
5
NB: Remember to report the actual data output as an appendix
to the report.
Transcribed Image Text:Observation or Quantity Price Advertising Distance (Number of Apartments) 1 28 250 11 12 2 70 400 24 3 43 450 15 5 4 32 550 31 8 5 42 576 34 4 6. 73 376 23 3 7 66 375 13 5 8 49 450 24 7 9 70 400 22 4 10 60 375 10 5 11 70 400 22 4 12 60 375 10 5 NB: Remember to report the actual data output as an appendix to the report.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 1 images

Blurred answer
Knowledge Booster
Optimization
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Trigonometry (MindTap Course List)
Trigonometry (MindTap Course List)
Trigonometry
ISBN:
9781337278461
Author:
Ron Larson
Publisher:
Cengage Learning
College Algebra
College Algebra
Algebra
ISBN:
9781337282291
Author:
Ron Larson
Publisher:
Cengage Learning
Holt Mcdougal Larson Pre-algebra: Student Edition…
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt
Linear Algebra: A Modern Introduction
Linear Algebra: A Modern Introduction
Algebra
ISBN:
9781285463247
Author:
David Poole
Publisher:
Cengage Learning