Enjoy the best grades that will raise your GPA.

Category: Data Analytics

Learning Goal: I’m working on a data analytics question and need an explanation

Learning Goal: I’m working on a data analytics question and need an explanation and answer to help me learn.Conduct a literature review of big data handling approaches in smart cities including techniques, algorithms, and architectures.You are to review the literature on smart cities and Big Data Analytics and discuss problems and gaps that have been identified in the literature. You will expand on the issue and how researchers have attempted to examine that issue by collecting data – you are NOT collecting data, just reporting on how researchers did their collection.
Paper Layout:Title Page
Table of contents: Use a Microsoft Enabled Table of Contents feature.
Background: Describe the issue, discuss the problem, and elaborate on any previous attempts to examine that issue. Be sure to include techniques, algorithms, and architectures.
Research Questions:In the identified problem area that you are discussing, what were the research questions that were asked? Be sure to include main research questions from all the literature you are reviewing.
Methodology:What approach did the researcher use, qualitative, quantitative, survey, case study? Describe the population that was chosen. You will discuss the methodology for all the literature you are reviewing.
Data Analysis:What were some of the findings, for example, if there were any hypotheses asked, were they supported?
Conclusions:What was the conclusion of any data collections, e.g., were research questions answered, were hypotheses supported? Be sure to also include the similarities and differences between the literature.
Paper requirements:Be a minimum of 7 pages in length, not including the required cover page and reference pages.
Follow APA 7 guidelines. Be sure to conduct research on formatting literature reviews.
Your literature review should include a minimum of 8 scholarly peer-reviewed journal articles. The UC Library is a great place to find resources.
Be clear and well-written, concise, and logical, using excellent grammar and style techniques. You are being graded in part on the quality of your writing. You can use Grammarly for help with your grammar and spelling.
NOTE: i need 7 pages minimum of the content excluding references & title page, in text citations, in APA format & references are important too. Also make sure you are NOT collecting data, just reporting on how researchers did their collection.

Which year has increasing trend of the average distance travelled?

Learning Goal: I’m working on a data analytics spreadsheet and need an explanation and answer to help me learn. I’m working on a data analytics spreadsheet and need an explanation and answer to help me learn.The Below Four Questions are Seperate Question with attached file below .Question-1). Danah is responsible for reporting the status of sales for his company. The following pie chart shows the percentages of closed sales in each of the top seven cities. Use a different type of chart to display the percentage of sales sold in each city that conveys the data better than the pie chart. Convert the pie chart to an Excel bar chart in order to improve readability.Question – 2).The attached shows the average monthly distance travelled (Billions of Miles) by vehicles on urban highways for five years.a. Use Excel to create sparklines for the average monthly vehicle distance travelled each year.b. Which year has decreasing trend of the average distance travelled? Which year has increasing trend of the average distance travelled?c. Use Excel to create a heat map for the average distance travelled by vehicles. Do you find the heat map or the sparklines to be better at communicating the trend of the average vehicle distance travelled over different years? Why?Question- 3).Below is a study on the number of accidents that occurred in ten U.S. states in different cities for three consecutive years.Create a PivotTable in Excel to answer the following questions. The PivotTable should group the number of accidentsinto yearly bins and display the sum of accidents that occurred each year in columns of Excel. Row labels should includethe accident locations and allow for grouping the locations into states or viewing by city. You should also sort thePivotTable so that the states with the greatest number of accidents between 2011 and 2013 appear at the top of the PivotTable. a. Which state had the greatest number of accidents between 2011 and 2013? Discuss in your Excel document uploaded.b. How many accidents occurred in the state of Colorado (CO) in 2012? In what cities did these accidents occur? Samec. Use the PivotTable’s filter capability to view only the accidents in Alabama (AL), Arizona (AZ), and Arkansas (AR) for the years 2011 through 2013. What is the total number of accidents in these states between 2011 and 2013? Discuss in Excel.d. Create a PivotChart to display a column chart that shows the total number of accidents in each year 2011 through 2013 in the state of California. Adjust the formatting of this column chart so that it best conveys the data. What does this column chart suggest about accidents between 2011 and 2013 in California? Discuss as above (your filename: AccidentsLastName.xlsx).Hint: You may have to switch the row and column labels in the PivotChart to get the best presentation for your PivotChart.Question – 4)Over the past few years the percentage of students who leave Dana College at the end of their first year has increased. Last year, Dana started voluntary one-credit hour-long seminars with faculty to help first-year students establish an on-campus connection. If Dana is able to show that the seminars have a positive effect on retention, college administrators will be convinced to continue funding this initiative. Dana’s administration also suspects that first-year students with lower high school GPAs have a higher probability of leaving Dana at the end of the first year. Data on the 500 first-year students from last year has been collected. Each observation consists of a first-year student’s high school GPA, whether they enrolled in a seminar, and whether they dropped out and did not return to Dana. Apply logistic regression to classify observations as dropped out or not dropped out by using GPA and Seminar as input variables and Dropped as the target (or response) variable.Download the file below and save locally as DroppedLastName.xlsx.
Clearly show in a Word document, how you obtained the glm-estimated coefficients of the estimated equation.
In your DroppedLastName.xlsx state in a column, the Estimated Probability of Dropped based these coefficients.
In your DroppedLastName.xlsx file, insert a diagram of Estimated Probability of Dropped against GPA.
Arbitrarily change some of the GPA values to illustrate that, indeed, your model follows Logistic regression.

Which year has decreasing trend of the average distance travelled?

Learning Goal: I’m working on a data analytics spreadsheet and need an explanation and answer to help me learn.The Below Four Questions are Seperate Question with attached file below . Question-1). Danah is responsible for reporting the status of sales for his company. The following pie chart shows the percentages of closed sales in each of the top seven cities. Use a different type of chart to display the percentage of sales sold in each city that conveys the data better than the pie chart. Convert the pie chart to an Excel bar chart in order to improve readability. Question – 2).The attached shows the average monthly distance travelled (Billions of Miles) by vehicles on urban highways for five years.a. Use Excel to create sparklines for the average monthly vehicle distance travelled each year.b. Which year has decreasing trend of the average distance travelled? Which year has increasing trend of the average distance travelled?c. Use Excel to create a heat map for the average distance travelled by vehicles. Do you find the heat map or the sparklines to be better at communicating the trend of the average vehicle distance travelled over different years? Why? Question- 3).Below is a study on the number of accidents that occurred in ten U.S. states in different cities for three consecutive years.Create a PivotTable in Excel to answer the following questions. The PivotTable should group the number of accidentsinto yearly bins and display the sum of accidents that occurred each year in columns of Excel. Row labels should includethe accident locations and allow for grouping the locations into states or viewing by city. You should also sort thePivotTable so that the states with the greatest number of accidents between 2011 and 2013 appear at the top of the PivotTable. a. Which state had the greatest number of accidents between 2011 and 2013? Discuss in your Excel document uploaded.b. How many accidents occurred in the state of Colorado (CO) in 2012? In what cities did these accidents occur? Samec. Use the PivotTable’s filter capability to view only the accidents in Alabama (AL), Arizona (AZ), and Arkansas (AR) for the years 2011 through 2013. What is the total number of accidents in these states between 2011 and 2013? Discuss in Excel.d. Create a PivotChart to display a column chart that shows the total number of accidents in each year 2011 through 2013 in the state of California. Adjust the formatting of this column chart so that it best conveys the data. What does this column chart suggest about accidents between 2011 and 2013 in California? Discuss as above (your filename: AccidentsLastName.xlsx).Hint: You may have to switch the row and column labels in the PivotChart to get the best presentation for your PivotChart. Question – 4)Over the past few years the percentage of students who leave Dana College at the end of their first year has increased. Last year, Dana started voluntary one-credit hour-long seminars with faculty to help first-year students establish an on-campus connection. If Dana is able to show that the seminars have a positive effect on retention, college administrators will be convinced to continue funding this initiative. Dana’s administration also suspects that first-year students with lower high school GPAs have a higher probability of leaving Dana at the end of the first year. Data on the 500 first-year students from last year has been collected. Each observation consists of a first-year student’s high school GPA, whether they enrolled in a seminar, and whether they dropped out and did not return to Dana. Apply logistic regression to classify observations as dropped out or not dropped out by using GPA and Seminar as input variables and Dropped as the target (or response) variable.Download the file below and save locally as DroppedLastName.xlsx.
Clearly show in a Word document, how you obtained the glm-estimated coefficients of the estimated equation.
In your DroppedLastName.xlsx state in a column, the Estimated Probability of Dropped based these coefficients.
In your DroppedLastName.xlsx file, insert a diagram of Estimated Probability of Dropped against GPA.
Arbitrarily change some of the GPA values to illustrate that, indeed, your model follows Logistic regression.

Do you find the heat map or the sparklines to be better at communicating the trend of the average vehicle distance travelled over different years?

Learning Goal: I’m working on a data analytics spreadsheet and need an explanation and answer to help me learn.The Below Four Questions are Seperate Question with attached file below . Question-1). Danah is responsible for reporting the status of sales for his company. The following pie chart shows the percentages of closed sales in each of the top seven cities. Use a different type of chart to display the percentage of sales sold in each city that conveys the data better than the pie chart. Convert the pie chart to an Excel bar chart in order to improve readability. Question – 2).The attached shows the average monthly distance travelled (Billions of Miles) by vehicles on urban highways for five years.a. Use Excel to create sparklines for the average monthly vehicle distance travelled each year.b. Which year has decreasing trend of the average distance travelled? Which year has increasing trend of the average distance travelled?c. Use Excel to create a heat map for the average distance travelled by vehicles. Do you find the heat map or the sparklines to be better at communicating the trend of the average vehicle distance travelled over different years? Why? Question- 3).Below is a study on the number of accidents that occurred in ten U.S. states in different cities for three consecutive years.Create a PivotTable in Excel to answer the following questions. The PivotTable should group the number of accidentsinto yearly bins and display the sum of accidents that occurred each year in columns of Excel. Row labels should includethe accident locations and allow for grouping the locations into states or viewing by city. You should also sort thePivotTable so that the states with the greatest number of accidents between 2011 and 2013 appear at the top of the PivotTable. a. Which state had the greatest number of accidents between 2011 and 2013? Discuss in your Excel document uploaded.b. How many accidents occurred in the state of Colorado (CO) in 2012? In what cities did these accidents occur? Samec. Use the PivotTable’s filter capability to view only the accidents in Alabama (AL), Arizona (AZ), and Arkansas (AR) for the years 2011 through 2013. What is the total number of accidents in these states between 2011 and 2013? Discuss in Excel.d. Create a PivotChart to display a column chart that shows the total number of accidents in each year 2011 through 2013 in the state of California. Adjust the formatting of this column chart so that it best conveys the data. What does this column chart suggest about accidents between 2011 and 2013 in California? Discuss as above (your filename: AccidentsLastName.xlsx).Hint: You may have to switch the row and column labels in the PivotChart to get the best presentation for your PivotChart. Question – 4)Over the past few years the percentage of students who leave Dana College at the end of their first year has increased. Last year, Dana started voluntary one-credit hour-long seminars with faculty to help first-year students establish an on-campus connection. If Dana is able to show that the seminars have a positive effect on retention, college administrators will be convinced to continue funding this initiative. Dana’s administration also suspects that first-year students with lower high school GPAs have a higher probability of leaving Dana at the end of the first year. Data on the 500 first-year students from last year has been collected. Each observation consists of a first-year student’s high school GPA, whether they enrolled in a seminar, and whether they dropped out and did not return to Dana. Apply logistic regression to classify observations as dropped out or not dropped out by using GPA and Seminar as input variables and Dropped as the target (or response) variable.Download the file below and save locally as DroppedLastName.xlsx.
Clearly show in a Word document, how you obtained the glm-estimated coefficients of the estimated equation.
In your DroppedLastName.xlsx state in a column, the Estimated Probability of Dropped based these coefficients.
In your DroppedLastName.xlsx file, insert a diagram of Estimated Probability of Dropped against GPA.
Arbitrarily change some of the GPA values to illustrate that, indeed, your model follows Logistic regression.

Explain why you chose that visualization to answer the question of interest and how it was created.

Learning Goal: I’m working on a data analytics case study and need an explanation and answer to help me learn.See below for your individual question of interest
You will be responsible for finding sources of data to answer the question of interest. These data sources need to be places that we can go to repeatedly to find information. For example, a website. Do not call people or the locations to get data.
You will be responsible for creating a visual in Excel which answers the question of interest. The visualization can come from the data you found.
After the case study reports are graded, the instructor will add your visualization to the class data dashboard. Here are some examples of data dasboards. Examples
Your report will address the question of interest, talk about your data sources and talk about the visualization. Explain why you chose that visualization to answer the question of interest and how it was created.
You will be submitting a written report in a Word document (not Excel). You may need to copy and paste the Excel visualization results into your Word document.
The written report should be at least 600 words (not including Excel outputs)
What are the results of health and safety inspections at the four following apartment complexes? Compare them for both health and safety inspections.
Olde Salem Village Aparments, 6084 Argyle Dr APT B, Falls Church, VA 22041
Parkwood Apartments, 3421 Glen Carlyn Dr, Falls Church, VA 22041
Hillwood Manor Apartments, 6079 Bellview Dr APT A, Falls Church, VA 22041
Vista Gardens Apartments, 6024 Vista Dr #104, Falls Church, VA 22041

Do you find the heat map or the sparklines to be better at communicating the trend of the average vehicle distance travelled over different years?

Learning Goal: I’m working on a data analytics spreadsheet and need an explanation and answer to help me learn.The Below Four Questions are Seperate Question with attached file below . Question-1). Danah is responsible for reporting the status of sales for his company. The following pie chart shows the percentages of closed sales in each of the top seven cities. Use a different type of chart to display the percentage of sales sold in each city that conveys the data better than the pie chart. Convert the pie chart to an Excel bar chart in order to improve readability. Question – 2).The attached shows the average monthly distance travelled (Billions of Miles) by vehicles on urban highways for five years.a. Use Excel to create sparklines for the average monthly vehicle distance travelled each year.b. Which year has decreasing trend of the average distance travelled? Which year has increasing trend of the average distance travelled?c. Use Excel to create a heat map for the average distance travelled by vehicles. Do you find the heat map or the sparklines to be better at communicating the trend of the average vehicle distance travelled over different years? Why? Question- 3).Below is a study on the number of accidents that occurred in ten U.S. states in different cities for three consecutive years.Create a PivotTable in Excel to answer the following questions. The PivotTable should group the number of accidentsinto yearly bins and display the sum of accidents that occurred each year in columns of Excel. Row labels should includethe accident locations and allow for grouping the locations into states or viewing by city. You should also sort thePivotTable so that the states with the greatest number of accidents between 2011 and 2013 appear at the top of the PivotTable. a. Which state had the greatest number of accidents between 2011 and 2013? Discuss in your Excel document uploaded.b. How many accidents occurred in the state of Colorado (CO) in 2012? In what cities did these accidents occur? Samec. Use the PivotTable’s filter capability to view only the accidents in Alabama (AL), Arizona (AZ), and Arkansas (AR) for the years 2011 through 2013. What is the total number of accidents in these states between 2011 and 2013? Discuss in Excel.d. Create a PivotChart to display a column chart that shows the total number of accidents in each year 2011 through 2013 in the state of California. Adjust the formatting of this column chart so that it best conveys the data. What does this column chart suggest about accidents between 2011 and 2013 in California? Discuss as above (your filename: AccidentsLastName.xlsx).Hint: You may have to switch the row and column labels in the PivotChart to get the best presentation for your PivotChart. Question – 4)Over the past few years the percentage of students who leave Dana College at the end of their first year has increased. Last year, Dana started voluntary one-credit hour-long seminars with faculty to help first-year students establish an on-campus connection. If Dana is able to show that the seminars have a positive effect on retention, college administrators will be convinced to continue funding this initiative. Dana’s administration also suspects that first-year students with lower high school GPAs have a higher probability of leaving Dana at the end of the first year. Data on the 500 first-year students from last year has been collected. Each observation consists of a first-year student’s high school GPA, whether they enrolled in a seminar, and whether they dropped out and did not return to Dana. Apply logistic regression to classify observations as dropped out or not dropped out by using GPA and Seminar as input variables and Dropped as the target (or response) variable.Download the file below and save locally as DroppedLastName.xlsx.
Clearly show in a Word document, how you obtained the glm-estimated coefficients of the estimated equation.
In your DroppedLastName.xlsx state in a column, the Estimated Probability of Dropped based these coefficients.
In your DroppedLastName.xlsx file, insert a diagram of Estimated Probability of Dropped against GPA.
Arbitrarily change some of the GPA values to illustrate that, indeed, your model follows Logistic regression.

© 2022 assignmetshive

Theme by Anders NorenUp ↑