Part I Excel(28 points) SEE THE ATTACHED EXCEL FILE TO ANSWER THESE QUESTIONS
Calculate a Frequency Table based on the “room_type” variable. ( 4 points)
Make a histogram using the frequency table above snip and paste it below. Make sure that your histogram looks aesthetically pleasing and only communicates relevant information about Room Type. (4 points)
For the “Price” variable what percentage of listings cost more than 100 dollars to rent? (3 points)
What is the latitude and longitude of the property with the highest and lowest price? You should have 2 sets of coordinates for this question. (3 points)
“Place your order now for a similar assignment and have exceptional work written by our team of experts, guaranteeing you A results.”
Attachments
20190424030503mapthesedatasandiego (18 kB)20190424030509san_diego___data_for_exam (121 kB)20190424030516final_exam_san_diego (640 kB)
