Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please utilize this dataset to generate descriptive statistics using R Studio in any way you find suitable. Additionally, consider employing data mining techniques such as

Please utilize this dataset to generate descriptive statistics using R Studio in any way you find suitable. Additionally, consider employing data mining techniques such as logistic regression, multiple linear regression, or simple linear regression.

The dataset pertains to Pennsylvania bridge information. Consequently, we aim to visualize a map displaying bridges older than 80 years and their corresponding districts on the state map.

Utilizing variables like age, condition, rating, inspection, and others, predict the risk of pavement over the next 10 years. Alternatively, analyze the data using maps, visuals, and data mining techniques of your choice, then provide a summary of your approach.

X Y age Category lengh Condition Rail Traffic Category lengh Condition Inspec Freq Daily Traffic Facility State House Districts County Municipality Code Covered Bridge City Code Highway Lanes Length Service Level MAINSPANS Material Main ON_UNDER Place Code Safey Level Bridge Erosion SENATE_DISTRICTS SKEW ST_RT_NO STATE_LOCAL SUB_AGENCY Sufficient Rating Toll Facility Traffic Direc Transit Rating Truck %
-76.548695 41.200905 88 L 27 F 2 L 27 F 24 50 T-720 pa 102 41216 0 41 5 2 27 1 1 3 1 38448 D 4 23 60 7216 L 216 48.5 3 2 2
-76.617095 40.376405 84 L 37 P 4 L 37 P 24 50 T-589 SHERKSCHURCH pa 84 38203 0 38 5 2 37 0 1 3 1 21224 D 7 48 90 7203 L 38 78.09999847 3 2 8 5
-79.111195 41.929605 69 L 26 P 2 L 26 P 24 100 T-568,EGYPT HOLLOW pa 71 61215 0 61 5 2 26 1 1 3 1 60480 B 3 21 37 7215 L 215 84.90000153 3 2 2
-76.466595 41.374605 82 L 41 F 2 L 41 F 24 108 T-328 pa 176 56208 0 56 5 1 41 1 1 3 1 41520 D 7 23 90 7208 L 208 27.10000038 3 3 2 0
-76.476295 39.802005 70 L 58 F 2 L 58 F 24 44 MUDDY CREEK RD. pa 63 66209 0 66 5 1 58 1 2 5 1 25408 D 4 28 90 7209 L 66 44.5 3 3 2 2
-78.824095 40.228405 124 L 26 F 2 L 26 F 24 300 24TH STREET pa 51 55422 0 55 5 2 26 1 1 3 1 85632 D 4 32 80 7422 L 422 47.90000153 3 2 3 1
-78.677295 40.897205 104 L 132 F 2 L 132 F 24 40 C. C. ROAD (T-418) pa 85 17217 0 17 5 1 132 0 1 3 1 31376 D 4 35 90 7217 L 17 65.19999695 3 3 3 0
-76.653295 40.989105 109 L 40 P 2 L 40 P 24 25 T-362 CTY # 18 pa 73 47208 0 47 5 2 40 0 1 1 1 79552 D 7 27 90 7208 L 47 67.19999695 3 3 2 0
-75.432295 40.933005 39 L 67 P 2 L 67 P 24 75 TREIBLE RD. pa 17 45202 0 45 5 2 67 1 2 5 1 13328 D 4 40 90 7202 L 202 82.09999847 3 2 8
-78.385695 40.171205 99 L 46 F 2 L 46 F 24 42 T-705,PINE HILL RD pa 46 5221 0 5 5 2 46 1 2 3 1 72656 D 7 32 60 7221 L 221 61.20000076 3 2 2
-76.294695 40.376905 94 L 34 G 4 L 34 G 24 500 EAST MAIN ST T-500 pa 95 38205 0 38 5 2 34 1 1 1 1 37392 B 3 48 90 7205 L 38 83.90000153 3 2 4 3
-79.298295 40.723505 94 L 50 F 4 L 50 F 24 400 T-689 PETERMAN HIL pa 15 3219 0 3 5 1 50 1 1 5 1 61576 D 4 41 90 7219 L 3 68.5 3 3 8 9
-80.380495 40.961405 92 L 369 P 2 L 369 P 24 50 OLD ROUTE 18 RT pa 51 37301 0 37 5 2 369 1 1 3 1 54768 B 3 50 52 7206 L 206 38 3 2 2 10
-79.222195 40.025805 124 L 46 P 3 L 46 P 24 50 T-364 JIMTOWN ROAD pa 86 55209 0 55 5 1 46 1 1 3 1 37920 D 4 32 90 7209 L 55 23 3 3 8
-75.480795 40.332605 121 L 172 F 2 L 172 F 24 600 SNYDER ROAD pa 30 46210 0 46 4 1 172 0 1 3 1 79040 D 4 24 90 7046 L 46 19.39999962 3 1 3 0
-79.829595 39.800305 58 L 27 P 3 L 27 P 24 28 T-373 pa 79 26213 0 26 5 1 27 1 1 3 1 54392 D 4 32 90 7213 L 26 61.09999847 3 3 8 1
-77.298595 40.639705 84 L 28 F 2 L 28 F 24 300 T-531 ROCKLAND RD pa 8 34203 0 34 5 2 28 8 1 3 1 25440 D 4 30 90 7203 L 203 70.09999847 3 2 2 5
-78.4457 40.888 119 L 42 F 2 L 42 F 24 0 KELLYTOWN ROAD pa 145 17222 0 17 5 1 42 0 2 3 1 40296 A 2 35 84 7222 L 222 24 3 3 2 0
-75.465795 40.213005 84 L 24 F 3 L 24 F 24 1300 TRAPPE ROAD pa 60 46213 0 46 5 2 24 0 1 1 1 59392 D 7 24 86 7213 L 213 78.69999695 3 2 3 11
-78.015495 40.023805 84 L 26 F 3 L 26 F 24 51 T422,CHERRY LANE R pa 109 29205 0 29 5 2 26 1 1 3 1 20112 D 7 30 78 7205 L 205 83 3 2 3
-80.053095 41.419705 116 L 24 P 2 L 24 P 24 43 Crouser School Rd pa 17 43215 0 43 5 1 24 1 1 3 1 49576 B 3 50 90 7215 L 43 61.90000153 3 3 2 4
-75.937295 39.814105 69 L 28 F 2 L 28 F 24 280 HALL ROAD pa 96 15224 0 15 5 2 28 0 1 3 1 45040 D 4 19 90 7224 L 224 60.90000153 3 2 8 3
-76.360595 41.152005 65 L 43 P 2 L 43 P 24 100 CTY BR#133 pa 78 19409 0 19 5 2 43 0 1 5 1 74184 D 7 27 90 7409 L 19 41.59999847 3 2 2 1

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

Linear Algebra A Modern Introduction

Authors: David Poole

4th edition

1285463242, 978-1285982830, 1285982835, 978-1285463247

More Books

Students also viewed these Mathematics questions