subject

Copy the attached dataset into your sqlda database. Find the MAX and MIN percentages of users by zip code. Using JOINs calculate the sales amounts for customers who live in high public transportation use areas and low public transportation use areas (Case statements). Calculate the average sales in those areas. Plot a histogram of the data in R or in Python. Group customers based on their public transportation usage and count the average number of transactions per customer. Export this data and create a scatterplot in R or Python. Discuss any recommendations you deduce from the plot. Submit a Word document with screenshots of your successful query, your histogram, and your scatter plot. Write your recommendation after the screenshots. Describe in your own words of what you are doing. Please make sure that your images are large enough and high enough resolution for the reader to see the text in your queries and the results.

ansver
Answers: 2

Another question on Computers and Technology

question
Computers and Technology, 23.06.2019 18:30
Janice recently received her college degree and is looking for a job. she is worried that since she just finished school, she will be required to repay her perkins and direct subsidized loans immediately. janice pulls out the paperwork she signed and reviews it again for repayment information. after reading all of the information, janice discovers that
Answers: 2
question
Computers and Technology, 23.06.2019 21:20
For positive constants a and b, the force between two atoms in a molecule is given f(r) = −a r2 + b r3 , where r > 0 is the distance between the atoms. note: a and b are upper case letters. (a) find f '(r) = (b) find the critical point for f(r). r = (c) find f ''(r) = (d) find the value of r so that f ''(r) = 0.
Answers: 1
question
Computers and Technology, 24.06.2019 00:40
What social factors affect your health
Answers: 3
question
Computers and Technology, 24.06.2019 21:30
How do i copy and paste equations and pictures like math graphs, to post on this site to get my questions answered?
Answers: 2
You know the right answer?
Copy the attached dataset into your sqlda database. Find the MAX and MIN percentages of users by zip...
Questions
question
Mathematics, 24.10.2021 21:00
question
Mathematics, 24.10.2021 21:00
question
History, 24.10.2021 21:00
question
Mathematics, 24.10.2021 21:00
question
History, 24.10.2021 21:00
Questions on the website: 13722367