Purpose  This assignment illustrates how data analytics can be used to create s

Purpose 
This assignment illustrates how data analytics can be used to create strategies for sustainable organizational success while integrating the organization’s mission with societal values. You’ll apply statistical time series modeling techniques to identify patterns and develop time-dependent demand models. You’ll practice organizing and delivering a presentation to senior decision-makers. The PowerPoint presentation includes an audio component in addition to speaker notes.  If you are unable to create an audio component on your computer, please write your narrative in the speaker note area for each slide.
Scenario: A city’s administration isn’t driven by the goal of maximizing revenues or profits but instead looks at improving the quality of life of its residents. Many American cities are confronted with high traffic and congestion. Finding parking spaces, whether in the street or a parking lot, can be time-consuming and contribute to congestion. Some cities have rolled out data-driven parking space management to reduce congestion and make traffic more fluid.
You’re a data analyst working for a mid-size city that has anticipated significant increments in population and car traffic. The city is evaluating whether it makes sense to invest in infrastructure to count and report the number of parking spaces available at the different parking lots downtown. This data would be collected and processed in real-time, feeding an app that motorists can access to find parking space availability in different parking lots throughout the city.
Instructions: Work with the provided Excel database. This database has the following columns:
LotCode: A unique code that identifies the parking lot
LotCapacity: A number with the respective parking lot capacity
LotOccupancy: A number with the current number of cars in the parking lot
TimeStamp: A day/time combination indicating the moment when occupancy was measured
Day: The day of the week corresponding to the TimeStamp
Insert a new column, OccupancyRate, recording occupancy rate as a percentage with one decimal. For instance, if the current LotOccupancy is 61 and LotCapacity is 577, then the OccupancyRate would be reported as 10.6 (or 10.6%).
Using the OccupancyRate and Day columns, construct box plots for each day of the week. You can use Insert > Insert Statistic Chart >Box and Whisker for this purpose. Is the median occupancy rate approximately the same throughout the week? If not, which days have lower median occupancy rates? Which days have higher median occupancy rates? Is this what you expected?
Using the OccupancyRate and LotCode columns, construct box plots for each parking lot. You can use Insert > Insert Statistic Chart >Box and Whisker for this purpose. Do all parking lots experience approximately equal occupancy rates? Are some parking lots more frequented than others? Is this what you expected?
Select any 2 parking lots. For each one, prepare a scatter plot showing the occupancy rate against TimeStamp for the week 11/20/2016 –11/26/2016. Are occupancy rates time-dependent? If so, which times seem to experience the highest occupancy rates? Is this what you expected?
Presentation:
Create a 10- to 12-slide presentation with speaker notes and audio. Your audience is the City Council members who are responsible for deciding whether the city invests in resources to set in motion the smart parking space app.
Complete the following in your presentation:
Outline the rationale and goals of the project.
Utilize boxplots showing the occupancy rates for each day of the week. Include your interpretation of the results.
Utilize box plots showing the occupancy rates for each parking lot. Include your interpretation of the results.
Provide scatter plots showing occupancy rate against the time of day of your selected two parking lots. Include your interpretation of the results.
Make a recommendation about continuing with the implementation of this project.

Researchers and policy makers are interested in identifying the factors that influence violent crime in the United States and whether or not these are the same across different parts of the country

Directions:
See the Assignment Module, Project Instructions page to download the data and questions.
Please read all instructions thoroughly, complete the data analysis, save the necessary screenshots and outputs.
Once you have finished, return to this page and open the quiz to enter your answers and upload the images – once it is opened it must be completed.
You must create/recode variables, conduct the appropriate univariate and bivariate analyses, and then answer the multiple choice questions.
For each research question, you are required to upload a Word document showing your work (screen shot, pivot tables, or output). You will not receive points for your answers if you do not upload a document showing your work.
The last section of this assignment requires you to provide a short summary of your findings.
Project Questions:
Researchers and policy makers are interested in identifying the factors that influence violent crime in the United States and whether or not these are the same across different parts of the country. Two factors are being discussed: poverty and whether the death penalty is legal. Therefore, you have been asked to conduct a study to answer the following research questions:
Does poverty influence violent crime among US states?
Does having the death penalty influence violent crime among US states?
Are there specific areas of the country where the death penalty is more common?
Does violent crime vary across regions of the country?
Does poverty vary across regions of the country?
Details:
To answer these questions, the concepts have been conceptualized/operationalized as:
Violent crime = the violent crime rate per (100,000) residents in 2014
The data came from the UCR and includes all violent crimes reported to the police
Death penalty legalization = whether or not a state has the death penalty
This information was pulled from BJS
Coded 0 = death penalty is not legal, 1 = death penalty is legal
Poverty = the percent of the population in each state that lived below the poverty line in 2014
This information came from the U.S. Census Bureau
Part of the County = region of the country as defined by the U.S. Census Bureau
Four regions coded:
1 = North
2 = Midwest
3 = West
4 = South
This means that you will need four variables: region of the country, death penalty, violent crime rate (per 100,000), and the percent of the population living below the poverty line.
Important:
Please use the data file provided to answer the research questions.
You must create/recode variables, conduct the appropriate univariate and bivariate analyses, and then answer the multiple choice questions.
For each research question, you are required to upload a Word document showing your work (screen shot, pivot tables, or output).
You will not receive points for your answers if you do not upload a document showing your work.
The last section of this assignment requires you to provide a short summary of your findings.
Directions
Using the data provided, answer each research question thoroughly.
For each of the research questions, you are required to recode variables, conduct the appropriate analysis, and then answer the multiple choice questions.
For each research question, you are also required to upload a print screen of your work. You will not receive points without proof of your work.
The final section of the assignment asks you to summarize your findings in a paragraph.
The assignment will be available on November 15 and is due on December 6th at 5:00 pm EST. After the due date, I will grade the uploaded files and the essay question and revise scores accordingly.
In the documents below, the assignment questions and data file allow students to review the questions and conduct analyses prior to opening the assignment (in quiz format) in Canvas. However, this list only includes the questions. It does not include the multiple choice response options.

Directions: See the Assignment Module, Project Instructions page to download the

Directions:
See the Assignment Module, Project Instructions page to download the data and questions.
Please read all instructions thoroughly, complete the data analysis, save the necessary screenshots and outputs.
Once you have finished, return to this page and open the quiz to enter your answers and upload the images – once it is opened it must be completed.
You must create/recode variables, conduct the appropriate univariate and bivariate analyses, and then answer the multiple choice questions.
For each research question, you are required to upload a Word document showing your work (screen shot, pivot tables, or output). You will not receive points for your answers if you do not upload a document showing your work.
The last section of this assignment requires you to provide a short summary of your findings.
Project Questions:
Researchers and policy makers are interested in identifying the factors that influence violent crime in the United States and whether or not these are the same across different parts of the country. Two factors are being discussed: poverty and whether the death penalty is legal. Therefore, you have been asked to conduct a study to answer the following research questions:
Does poverty influence violent crime among US states?
Does having the death penalty influence violent crime among US states?
Are there specific areas of the country where the death penalty is more common?
Does violent crime vary across regions of the country?
Does poverty vary across regions of the country?
Details:
To answer these questions, the concepts have been conceptualized/operationalized as:
Violent crime = the violent crime rate per (100,000) residents in 2014
The data came from the UCR and includes all violent crimes reported to the police
Death penalty legalization = whether or not a state has the death penalty
This information was pulled from BJS
Coded 0 = death penalty is not legal, 1 = death penalty is legal
Poverty = the percent of the population in each state that lived below the poverty line in 2014
This information came from the U.S. Census Bureau
Part of the County = region of the country as defined by the U.S. Census Bureau
Four regions coded:
1 = North
2 = Midwest
3 = West
4 = South
This means that you will need four variables: region of the country, death penalty, violent crime rate (per 100,000), and the percent of the population living below the poverty line.
Important:
Please use the data file provided to answer the research questions.
You must create/recode variables, conduct the appropriate univariate and bivariate analyses, and then answer the multiple choice questions.
For each research question, you are required to upload a Word document showing your work (screen shot, pivot tables, or output).
You will not receive points for your answers if you do not upload a document showing your work.
The last section of this assignment requires you to provide a short summary of your findings.
Directions
Using the data provided, answer each research question thoroughly.
For each of the research questions, you are required to recode variables, conduct the appropriate analysis, and then answer the multiple choice questions.
For each research question, you are also required to upload a print screen of your work. You will not receive points without proof of your work.
The final section of the assignment asks you to summarize your findings in a paragraph.
The assignment will be available on November 15 and is due on December 6th at 5:00 pm EST. After the due date, I will grade the uploaded files and the essay question and revise scores accordingly.
In the documents below, the assignment questions and data file allow students to review the questions and conduct analyses prior to opening the assignment (in quiz format) in Canvas. However, this list only includes the questions. It does not include the multiple choice response options.

Run a series of queries. First run a query that finds all larcenies that occurred in May 2002.

Download Samples.accdb to your desktop.  Rename it to LastName_Incidents.accdb (where “LastName” is your last name,) and open the file.
Run a series of queries.
First run a query that finds all larcenies that occurred in May 2002.
Note the use of the “wildcard” characters.  Read the Access Help file titled, “Examples of Access Query Criteria.”  Generally you are using the * and ? characters to do this.
Second, run an update query.  You are to replace the term “Shoplifting” with “Larceny from Store.”
Third, re-run the first larceny query after having run the replacements.
Copy and paste all the tables produced into a MS Word .doc.
Download the People.txt file attached.  This is the same file as previously used.
Create a new access database, LastName_People.
Import the data using the import function of Access.
Once imported, update the fields to their proper names, i.e. FirstName, LastName, etc.
Then add a field for state.
Using the update query, have everyone who lives in “Metropolis” or “Gotham City” be updated to live in “NY” for the state.
Then run a query for everyone who lives in NY.
Upload both Access databases, which should include your query tables, and the MS Word doc.  Make sure that your name appears in the file name for both files, and make sure that your tables are properly labeled in the .doc file you created.

I will include the assignment details below. I have already done the first part

I will include the assignment details below. I have already done the first part of the assignment and I will include the survey and consent form I created. I will also add a link to the results of the survey. Your job is to do the second part of the assignment which is the data analysis
Link to survey :https://www.surveymonkey.com/stories/SM-CFW5X9JQ/

I need dataset(s) (with source link(s)) in order to determine the current state

I need dataset(s) (with source link(s)) in order to determine the current state of the Diagnosis Gaps caused by the delaying health screenings and routine medical check-ups because of COVID-19. I need the data to be Time series one at least over the last 2 years, or two ‘of the same’ dataset one pre-Covid and one post-Covid in order to answer the this question. I also need a simple machine learning model that predicts the narrowing of these gaps.
Let me say it again clearer: During the initial months of Covid-19 pandemic and associated lockdowns, regular health and diagnosis screenings were delayed. While minor checkups such as dental might not cause major health concerns to healthy individuals, other important once such as annual screenings for breast cancer may now present an advanced state case of the disease. This have caused diagnosis gaps to emerge. MY GOAL is to establish pre-covid baselines utilizing claims data in order understand the current state of the screenings and diagnosis gaps. . I also want to build a scalable model that predicts the narrowing of these gaps.
To put what I am asking in one sentence: The goal of this project is to establish pre-covid baselines in order to understand the current states of the screenings and diagnosis gaps and to predict the narrowing of these gaps using machine learning.
I want it to be as simple as possible, and as straight forward as possible. I am thinking of using the averages pre-covid and the averages post-covid to determine the current state of the diagnosis gaps caused by the pandemic.
I need the Jupyter Notebook to be clearly stating what is and why you determine to use each block of code using Jupyter Notebook markdown so I understand what is going on.