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
Get step-by-step solutions from verified subject matter experts
