Project #77345 - need to create as many graphs out of Excel sheet data

1. I would like as many bar graphs out of this excel sheet as possible please. they should be correlating the (gate.rush) column with other single columns to show which column is a strong factor in affecting the gate rush decision by drivers. Any other graph Ideas are welcome as an addition.

2. Also, I would like to have smaller tables that show the number and type of illegal activities made by each age catagory. I put an example table below my data. If you can do many of these tables that would be great.

PLEASE SEE TABLES AND GRAPHS ON PAGES 19 to 26 in the example report I attached.


to explain the excel sheet:

the data is taken at a highway-railroad grade crossing. I noted the diver behavior each time a train was coming and the gates were closing.

here are what the columns stand for:

day.night: if the time was day I would input "d" and input "n" for night.

weather: "c" stands for clear.

movement: "T" is through the intersection, "R" and "L" are right and left, "U" is Uturn.

illegal.uturn: "g" means no illegal uturn and "p" means an illegal uturn was made

cross.red: "n" means no crossing was made while traffic light was red, "y" means the car crossed while light was red.

hv: stands for heavy vehicle, "H" for trucks and busses, "s" for single unit passenger vehicles.

alt.route: means taking an alternate route when they saw the train coming.

other.unsafe: means weather there was another unsafe action by the driver.

 

gate.rush: "1" Driver passed through the gate while it was descending

"2" driver passed through the gate while it was ascending after the train passed.

"3" the driver stopped legally and acted as they should.

illegal: "1" means this was an illegal act (such as going through moving gates)

"0" means this driver acted legally (safe driver)

 

 

thank you for your time, I would also like to post another job for R software using the same excel sheet. If you are an expert in multinomial and binomial regression using let me know and I will send you my report.

Subject Mathematics
Due By (Pacific Time) 07/26/2015 12:00 am
Report DMCA
TutorRating
pallavi

Chat Now!

out of 1971 reviews
More..
amosmm

Chat Now!

out of 766 reviews
More..
PhyzKyd

Chat Now!

out of 1164 reviews
More..
rajdeep77

Chat Now!

out of 721 reviews
More..
sctys

Chat Now!

out of 1600 reviews
More..
sharadgreen

Chat Now!

out of 770 reviews
More..
topnotcher

Chat Now!

out of 766 reviews
More..
XXXIAO

Chat Now!

out of 680 reviews
More..
All Rights Reserved. Copyright by AceMyHW.com - Copyright Policy