logo

Analysis of Desklib's Online Library for Study Material

Build a model to distinguish competitive auctions from non-competitive ones using data from eBay.com. Pre-process the data by creating dummy variables for categorical predictors and split the data into training and validation datasets. Explore the dataset by applying appropriate techniques.

31 Pages3935 Words155 Views
   

Added on  2023-05-28

About This Document

This text provides an analysis of Desklib's online library for study material. It covers seller ratings, close price, and open price, as well as the frequency of categories, currency, and duration. The text also explores correlations and logistic regression analysis. The subject is not specified, nor is the course code or college/university mentioned.

Analysis of Desklib's Online Library for Study Material

Build a model to distinguish competitive auctions from non-competitive ones using data from eBay.com. Pre-process the data by creating dummy variables for categorical predictors and split the data into training and validation datasets. Explore the dataset by applying appropriate techniques.

   Added on 2023-05-28

ShareRelated Documents
Appendix A
Explore
Case Processing Summary
Cases
Valid Missing Total
N Percent N Percent N Percent
sellerRating 1972 100.0% 0 0.0% 1972 100.0%
ClosePrice 1972 100.0% 0 0.0% 1972 100.0%
OpenPrice 1972 100.0% 0 0.0% 1972 100.0%
Descriptives
Statistic Std. Error
sellerRating
Mean 3560.24 134.505
95% Confidence Interval for
Mean
Lower Bound 3296.45
Upper Bound 3824.03
5% Trimmed Mean 2481.31
Median 1853.00
Variance 35676860.795
Std. Deviation 5973.011
Minimum 0
Maximum 37727
Range 37727
Interquartile Range 2785
Skewness 3.219 .055
Kurtosis 10.092 .110
ClosePrice
Mean 36.4491 2.01530
95% Confidence Interval for
Mean
Lower Bound 32.4967
Upper Bound 40.4014
5% Trimmed Mean 21.3816
Median 9.9950
Variance 8009.151
Std. Deviation 89.49386
Minimum .01
Maximum 999.00
Range 998.99
Interquartile Range 23.10
Skewness 6.057 .055
Analysis of Desklib's Online Library for Study Material_1
Kurtosis 45.132 .110
OpenPrice
Mean 12.9260 .87500
95% Confidence Interval for
Mean
Lower Bound 11.2100
Upper Bound 14.6420
5% Trimmed Mean 7.4521
Median 4.5000
Variance 1509.805
Std. Deviation 38.85621
Descriptives
Statistic Std. Error
OpenPrice Minimum .01
Maximum 999.00
Range 998.99
Interquartile Range 8.76
Skewness 13.533 .055
Kurtosis 272.791 .110
Extreme Values
Case Number Value
sellerRating
Highest 1 23 37727
2 84 37727
3 1222 37727
4 1332 37727
5 26 34343
Lowest 1 1963 0
2 1965 1
3 1868 1
4 1863 1
5 1843 1a
ClosePrice Highest 1 1972 999.00
2 1921 971.00
3 1741 863.28
4 513 860.00
5 514 860.00
Lowest 1 23 .01
2 22 .01
3 21 .01
Analysis of Desklib's Online Library for Study Material_2
4 20 .01
5 19 .01b
OpenPrice
Highest 1 1972 999.00
2 1971 650.00
3 1970 549.00
4 1968 359.95
5 1969 300.00
Lowest
1 514 .01
2 513 .01
3 481 .01
4 475 .01
5 339 .01b
a. Only a partial list of cases with the value 1 are shown in the table
of lower extremes.
b. Only a partial list of cases with the value .01 are shown in the table of lower extremes.
Tests of Normality
Kolmogorov-Smirnova Shapiro-Wilk
Statistic df Sig. Statistic df Sig.
sellerRating .306 1972 .000 .536 1972 .000
ClosePrice .342 1972 .000 .377 1972 .000
OpenPrice .370 1972 .000 .263 1972 .000
a. Lilliefors Significance Correction
sellerRating
Analysis of Desklib's Online Library for Study Material_3
Analysis of Desklib's Online Library for Study Material_4
Analysis of Desklib's Online Library for Study Material_5
Correlations
Correlations
sellerRating ClosePrice OpenPrice
sellerRating
Pearson Correlation 1 .000 -.041
Sig. (2-tailed) .994 .068
N 1972 1972 1972
ClosePrice
Pearson Correlation .000 1 .477**
Sig. (2-tailed) .994 .000
N 1972 1972 1972
OpenPrice
Pearson Correlation -.041 .477** 1
Sig. (2-tailed) .068 .000
N 1972 1972 1972
**. Correlation is significant at the 0.01 level (2-tailed).
Analysis of Desklib's Online Library for Study Material_6
Appendix B
Frequencies
Statistics
Category currency Duration endDay
N Valid 1810 1810 1810 1810
Missing 0 0 0 0
Frequency Table
Category
Frequency Percent Valid Percent Cumulative
Percent
Valid
Antique/Art/Craft 176 9.7 9.7 9.7
Automotive 162 9.0 9.0 18.7
Books 53 2.9 2.9 21.6
Business/Industrial 18 1.0 1.0 22.6
Clothing/Accessories 118 6.5 6.5 29.1
Coins/Stamps 34 1.9 1.9 31.0
Collectibles 220 12.2 12.2 43.1
Computer 32 1.8 1.8 44.9
Electronics 53 2.9 2.9 47.8
EverythingElse 17 .9 .9 48.8
Health/Beauty 64 3.5 3.5 52.3
Home/Garden 101 5.6 5.6 57.9
Jewelry 60 3.3 3.3 61.2
Music/Movie/Game 399 22.0 22.0 83.3
Photography 11 .6 .6 83.9
Pottery/Glass 18 1.0 1.0 84.9
SportingGoods 71 3.9 3.9 88.8
Toys/Hobbies 203 11.2 11.2 100.0
Total 1810 100.0 100.0
Analysis of Desklib's Online Library for Study Material_7
currency
Frequency Percent Valid Percent Cumulative
Percent
Valid
EUR 525 29.0 29.0 29.0
GBP 145 8.0 8.0 37.0
US 1140 63.0 63.0 100.0
Total 1810 100.0 100.0
Duration
Frequency Percent Valid Percent Cumulative
Percent
Valid
1 19 1.0 1.0 1.0
3 204 11.3 11.3 12.3
5 377 20.8 20.8 33.1
7 913 50.4 50.4 83.6
10 297 16.4 16.4 100.0
Total 1810 100.0 100.0
endDay
Frequency Percent Valid Percent Cumulative
Percent
Valid
Fri 263 14.5 14.5 14.5
Mon 452 25.0 25.0 39.5
Sat 334 18.5 18.5 58.0
Sun 319 17.6 17.6 75.6
Thu 200 11.0 11.0 86.6
Tue 169 9.3 9.3 96.0
Wed 73 4.0 4.0 100.0
Total 1810 100.0 100.0
Analysis of Desklib's Online Library for Study Material_8

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Finance & Funding in Travel Tourism - Assignment
|13
|686
|120

SPSS Data Analysis: Relations and Variable Analysis
|28
|3462
|497