Question: ssignment #9Student Name:____________________ RMU#:_______________ Please use the worksheet SONY for Sony PlayStation auction data. The three columns are: 1) Auction ID, 2) # of bids,

ssignment #9Student Name:____________________ RMU#:_______________ Please use the worksheet "SONY" for Sony PlayStation auction data. The three columns are: 1) Auction ID, 2) # of bids, and 3) Auction winning prices. Please use Python to do the following works.1.Import the data into a dataframe named YourLastNameData. For example, TuData2.Calculate the mean, mode, min, and max of "auction winning prices".3.Please create a scatter plot for "# of bids" and "auction winning prices" with a trend line with R. What does the line can briefly tell us? 4.Please get and test the correlation coefficient between # of bids and Auction winning prices. Is it significant or not? 5.Suppose you want to use # of bids to predict prices. Please use Python to run a simple linear regression. Please show the regression summary. Is this model good enough? Why or why not

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!