Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

How do i find the value of test statistic and p value? How do I solve the 4th question? A random sample of 126 artworks

image text in transcribedimage text in transcribed

How do i find the value of test statistic and p value? How do I solve the 4th question?

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed
A random sample of 126 artworks created within the last three years and sold at auction has been selected to study art auction price and prior exhibition. Some of the variables recorded for each artwork are listed below. Variable Description subid Subject ID medium type of artwork exhibWeeks the number of weeks the artwork was exhibited before the auction price sale price (in thousands) Import the data set included in the file mple. csv in Excel. To do this, you need to click on the link above and save the data file in a convenient location on your PC (in your browser, File and Save). Next open Excel, click File in the Menu, select Open and navigate to the file you previously saved - or simply double-click on it, Excel should open automatically. Use Excel andfor probTooI, and appropriate hypothesis tests, to address the following research question. Assume all the test assumptions are verified. Research question: Can linear regression be used to predict sale price (in thousands) from the number of weeks the artwork was exhibited before the auction? Report the value of the estimated slope [use at least 4dp]: Report the value of the test statistic [use at least 2dp]: Report the p-value [use at least 3dp]: What percentage of the variation in the response variable cannot be explained by the model? Please report a number between 0 and 100 [use at least 1dp]. What is the decision of the test? Sule subj1 subj2 subj3 subj4 subj5 subj6 subj7 subjB subj9 subj10 subj11 subj12 subj13 subj14 subj15 subj16 subj17 subj18 subj19 subj20 subj21 subj22 subj23 subj24 subj25 subj26 subj27 subj28 subj29 subj30 subj31 subj32 subj33 subj34 subj35 subj36 medium painting painting sculpture sculpture sculpture painting sculpture sculpture painting sculpture sculpture painting sculpture painting sculpture painting sculpture painting sculpture painting sculpture painting sculpture sculpture sculpture painting painting sculpture sculpture painting sculpture painting painting painting painting painting exhibWeeks price 21 47 60 59 46 40 53 60 21 11 58 50 28 18 13 52 57 56 12 59 49 37 38 31 49 52 52 18 54 36 45 15 43 11 39 22 57.4 83.54 75.85 80.18 75.27 59.8 75.15 81.5 42.8 42 75.59 85.15 55.28 51.03 55.58 59.5 79.15 58.57 59.95 94.83 95.91 54.3 53.09 41.7 55.55 59.05 83.83 44.83 73.07 80.89 59.2 39.14 49.82 54.81 53.81 50.75 sculpture painting painting painting sculpture painting sculpture sculpture painting sculpture painting sculpture sculpture sculpture sculpture painting painting sculpture sculpture sculpture painting painting painting sculpture painting painting sculpture sculpture sculpture sculpture painting sculpture painting sculpture sculpture painting painting sculpture 37 16 21 25 56 32 47 16 35 37 43 17 53 32 54 28 15 38 17 388% 37 55 45 17 $$ 37 53 71.38 47.45 60.75 66.53 74.04 70.59 85 80.69 38.61 69.23 70.48 75.24 69.58 63.01 36.8 65.14 64.73 60.56 53.09 56.89 68.8 76.7 44.74 39.29 89.16 71.78 42.17 59.79 52.21 94.21 52.31 78.48 56.15 82 81.86 76.55 78.05 76.77 subj100 subj101 subj102 subj103 subj104 subj105 subj105 subj107 subj108 subj109 subj110 subj111 painting sculpture sculpture sculpture sculpture painting painting painting painting painting painting painting painting painting sculpture sculpture sculpture sculpture sculpture sculpture sculpture painting painting sculpture painting sculpture sculpture sculpture sculpture sculpture painting sculpture sculpture sculpture sculpture sculpture sculpture 53 37 12 47 12 39 24 32 41 33 45 50 21 35 29 14 25 35 35 31 25 10 49 14 25 47 19 22 24 31 55 75.85 54.25 55.57 53.09 54.51 57.31 71.45 55.57 70.77 70.52 57.55 73.32 59.55 83.09 51.87 51.59 79.15 57.72 72.07 58.52 84.57 52.05 55.88 51.77 43.52 89.45 39.85 57.28 51.77 37.95 85.43 34.33 73.35 41.27 72.57 49.74 73.53 subj112 subj113 subj114 subj115 subj116 subj117 subj118 subj119 subj120 subj121 subj122 subj123 subj124 subj125 subj125 painting painting painting sculpture sculpture sculpture painting sculpture painting sculpture sculpture painting painting painting painting 24 30 38 46 20 42 22 29 42 35 29 15 55 34 63.39 71.39 61.89 67.27 61.38 75.44 42.19 72.7 81.35 77.14 65.43 69.86 42.88 90.9 82.82

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Intermediate Algebra Functions & Authentic Applications

Authors: Jay Lehmann

5th Edition

0321923464, 9780321923462

More Books

Students also viewed these Mathematics questions

Question

6. How can hidden knowledge guide our actions?

Answered: 1 week ago