As an independent statistical consultant, you have been contracted by Henry Oldman, a collector of grandfather clocks. Mr Oldman has observed auction sales of 32 grandfather clocks, collecting data...

1 answer below »

View more »
Answered Same DayNov 14, 2021

Answer To: As an independent statistical consultant, you have been contracted by Henry Oldman, a collector of...

Pooja answered on Nov 17 2021
152 Votes
Introduction
The variable to be predicted is the selling price of the clock. The variable on the basis of which predictions are made is age of the clock, expected bidders, and quality of the clock. I want to build a multiple regression model that can predict the selling price of Clock on th
e basis of its age, bidders, and quality.
Data
The variables which are measured by the ratio scale of measurement are the selling price of the clock, age of the clock, and expected bidders on the clock. The variable which is measured by the nominal scale of measurement is the quality of the clock. The quality of the clock is categorised as either good or normal. The good quality clock is coded as 1 and the normal quality clock is coded as 0.
Analysis
The dependent variable is the selling price which is plotted on the y-axis. The independent variables are the age of the clock, the number of Bidders on the clock and the quality of the clock. The independent variables are plotted on the x-axis in the scatter plot. The three-scatter plot is given below.

There is a strong positive linear relationship between the age of the clock and its selling price. An upward trend with all points close to each other is an indication for the same. With an increase in the age of the clock, the selling price increases drastically
There is a moderate positive linear relationship between the number of bidders on the clock and its selling price. An upward trend with all points moderately close to each other is an indication for the same. With an increase in the bidders on the clock, the selling price also increases.
The box plot for price bidders and age is given below. The box plot is plotted for the variables which are measured by the ratio scale of measurement.
There are no significant outliers in the data set. The middle line of the box in the box plot indicates that the distribution for all the three variables is approximately normal.
The multiple Regression model is given by:  selling price = -1284.2193 + 12.6208*age + 85.7962*bidders + 124.0003*quality
    Regression Analysis
    
    
    Regression Statistics
    Multiple R
    0.9537
    R Square
    0.9095
    Adjusted R Square
    0.8998
    Standard Error
    126.8486
    Observations
    32
    ANOVA
    
    
    
    
    
     
    df
    SS
    MS
    F
    Significance F
    Regression
    3
    4529864.1646
    1509954.7215
    93.8410
    0.0000
    Residual
    28
    450535.8354
    16090.5656
    
    
    Total
    31
    4980400.0000
     
     
     
     
    Coefficients
    Standard Error
    t Stat
    P-value
    Lower 95%
    Upper 95%
    Intercept
    -1284.2193
    165.2268
    -7.7725
    0.0000
    -1622.6710
    -945.7676
    Age
    12.6208
    0.8684
    14.5336
    0.0000
    10.8420
    14.3996
    Bidders
    85.7962
    8.3032
    10.3329
    0.0000
    68.7878
    102.8046
    Quality
    124.0003
    45.6578
    2.7159
    0.0112
    30.4745
    217.5261
With 1 year an increase in age of the clock, the price of the clock is increased by $12.6208. with...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here
April
January
February
March
April
May
June
July
August
September
October
November
December
2025
2025
2026
2027
SunMonTueWedThuFriSat
30
31
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
1
2
3
00:00
00:30
01:00
01:30
02:00
02:30
03:00
03:30
04:00
04:30
05:00
05:30
06:00
06:30
07:00
07:30
08:00
08:30
09:00
09:30
10:00
10:30
11:00
11:30
12:00
12:30
13:00
13:30
14:00
14:30
15:00
15:30
16:00
16:30
17:00
17:30
18:00
18:30
19:00
19:30
20:00
20:30
21:00
21:30
22:00
22:30
23:00
23:30