- Questions & Answers
- Accounting
- Computer Science
- Automata or Computationing
- Computer Architecture
- Computer Graphics and Multimedia Applications
- Computer Network Security
- Data Structures
- Database Management System
- Design and Analysis of Algorithms
- Information Technology
- Linux Environment
- Networking
- Operating System
- Software Engineering
- Big Data
- Android
- iOS
- Matlab

- Economics
- Engineering
- Finance
- Thesis
- Management
- Science/Math
- Statistics
- Writing
- Dissertations
- Essays
- Programming
- Healthcare
- Law

- Log in | Sign up

Doing in SAS Enterprise software

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 on: · The selling price (Price) · The age of the clock (Age) · The number of bidders on the clock (Bidders) · The quality of the clock (Quality: 1=good, 0=normal) Mr Oldman is interested in selling three clocks from his collection: Clock name Age (years) Expected bidders Quality Masterton 130 5 Good Palmerston 140 8 Normal Halverson 175 10 Good He would like you to predict the selling price of each clock, and also to tell him whether you believe he should spend $200 to restore the Palmerston's clock condition from Normal to Good. Tasks: Require doing in SAS Enterprise 1. Create box-and-whisker and scatter plots (as appropriate) to show how each of the x-variables affects the price of the clocks. 2. Create a multiple regression model for price using all three x-variables. 3. Interpret the parameter estimates. 4. Predict the price of each of Mr Oldman's three clocks. Provide the most likely selling price, along with a 95% prediction interval. Tell Mr Oldman how to interpret the 95% prediction interval. 5. Decide (using your model) whether spending $200 to upgrade the Palmerston clock from Normal to Good quality is worthwhile (i.e. can be expected to earn more than $200 back at auction). 6. Write your findings in a case report, and upload it below by Sunday night.

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 on: · The selling price (Price) · The age of the clock (Age) · The number of bidders on the clock (Bidders) · The quality of the clock (Quality: 1=good, 0=normal) Mr Oldman is interested in selling three clocks from his collection: Clock name Age (years) Expected bidders Quality Masterton 130 5 Good Palmerston 140 8 Normal Halverson 175 10 Good He would like you to predict the selling price of each clock, and also to tell him whether you believe he should spend $200 to restore the Palmerston's clock condition from Normal to Good. Tasks: Require doing in SAS Enterprise 1. Create box-and-whisker and scatter plots (as appropriate) to show how each of the x-variables affects the price of the clocks. 2. Create a multiple regression model for price using all three x-variables. 3. Interpret the parameter estimates. 4. Predict the price of each of Mr Oldman's three clocks. Provide the most likely selling price, along with a 95% prediction interval. Tell Mr Oldman how to interpret the 95% prediction interval. 5. Decide (using your model) whether spending $200 to upgrade the Palmerston clock from Normal to Good quality is worthwhile (i.e. can be expected to earn more than $200 back at auction). 6. Write your findings in a case report, and upload it below by Sunday night.

Answered Same DayNov 14, 2021

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

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

- This assignment is suppose to be an R studio sheet which is then knited into an R markdown file and word doc. The instructions are attached in greater detail. It is for a linear Regression & Analysis...SolvedApr 02, 2024
- LAB 1Due date: Mon 02/26/24 by end of day. Instructions: You are required to work individually. Use R Markdown and Knit to render a pdf or a word document. Upload the document back in...SolvedFeb 26, 2024
- Linear Regression 20%Use Excel to run a linear regression on the Quiz 2 Dataset tabusing donor_weight as the independent variable.Save the regression results on a new sheet in...SolvedOct 27, 2023
- Please cheek the all the sheet of excel file then do the quiz. submit it as early as possible.Oct 27, 2023
- Dear Sir, Read all the sheet in excel sheet then do the quiz. Do solution of 5 sheet and data set also in same of data set. Please do it properly last sheet has some hints. Hopefully i will get the...Oct 27, 2023
- Dear Sir, Read all the sheet in excel sheet then do the quiz. Do solution of 5 sheet and data set also in same of data set. Please do it properly last sheet has some hints. Hopefully i will get the...Oct 27, 2023
- Please follow the instructions. and write down the solution of topic problems along with others part of the assignment. moreover, I write the hypothesis after analysis write down which we accept or...SolvedOct 25, 2023
- 1. Review the powerpoint material for how to calculate2. Do the calculations/analysis for the 4 questions in the excel document (show your work)3. Answer the 4 questions based on the analysis...SolvedSep 14, 2023
- Prof. M. BacolodMN 4761Replication Exercise #2Promotion Policy and Diff-in-diff Estimation1. Read Ahn, T, J Niven, and A Veilleux (2021), How long have you been waiting? Explaining the role of...SolvedJul 15, 2023
- 1ECON 104Summer 2023Assignment 1In this assignment, you will estimate the effect of an effort to increase voter turnoutthrough encouraging phone calls. Voters were randomly assigned to get...SolvedJul 01, 2023

Copy and Paste Your Assignment Here

Copyright © 2024. All rights reserved.