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, 22.06.2019 09:40
In the lab, which of the following displayed a list of all installed services and included a description of the service, the current state, and whether the service started automatically or manually? a. the services manager b. the applications summary c. the recommended services d. list the safe services list
Answers: 2
question
Computers and Technology, 22.06.2019 10:20
Print "usernum1 is negative." if usernum1 is less than 0. end with newline. convert usernum2 to 0 if usernum2 is greater than 10. otherwise, print "usernum2 is less than or equal to 10.". end with newline
Answers: 3
question
Computers and Technology, 22.06.2019 19:30
Avariable definition defines the name of a variable that will be used in a program, as well as
Answers: 3
question
Computers and Technology, 23.06.2019 19:30
Of the following pieces of information in a document, for which would you most likely insert a mail merge field?
Answers: 3
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, 02.12.2020 05:30
question
Mathematics, 02.12.2020 05:30
question
Mathematics, 02.12.2020 05:30
question
Mathematics, 02.12.2020 05:30
question
Geography, 02.12.2020 05:30
Questions on the website: 13722363