1 Page Data Analysis Prompt Perform a data assessment on the Milestone One Data. In order to perform a complete data assessment, you must complete each of

1 Page Data Analysis

Prompt

Perform a data assessment on the Milestone One Data. In order to perform a complete data assessment, you must complete each of the following:

  • First Impressions: Look at the Excel file and discuss the following: What kind of information do you think this data set contains? Identify the different column headers. Based on what you see, make your best approximation about the type of information included in this data set.
  • Mean, Minimum, and Maximum: Choose two different columns and calculate the mean, minimum, and maximum of each of the columns. Record your column selections and your results. Calculate the mean, minimum, and maximum of the corresponding columns in the other tab (for example, if you calculate using the Firefighter tab first, move to the Police tab next and do the calculation on the column with the same header).
  • Findings: Now that you have completed the above, discuss the findings from your data assessment. For example, discuss why you chose to look into certain columns or rows and what the answers have revealed about the potential of the information housed in the data. Consider what questions arose as you were looking at the data.
  • Next Steps: Describe what you plan to do to further analyze the data. For example, how might you reorganize the data, or what columns and rows are you particularly interested in analyzing further? Be sure to explain your rationale.

Tip: When choosing columns to perform these calculations, consider which columns are most interesting to you. For example, would you like to compare salaries or benefits? Both?

What to Submit

Your deliverable for this assignment should be a one-page Excel or Word document. You may list your answers to the above questions in bullets or in paragraph format.

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

In this section of your white paper, you will analyze the strategic management practices of the two organizations. Specifically, you should address the

In this section of your white paper, you will analyze the strategic management practices of the two organizations. Specifically, you should address the following critical elements: Strategic Management: Compare the elements of strategic planning and the strategic management process used by the two organizations. In other words, how did the organizations

Module 1 – SLPEquilibrium, Supply and DemandAssignment OverviewProfessional Application with Excel Throughout the MBA program, you will have multiple

Module 1 – SLPEquilibrium, Supply and DemandAssignment OverviewProfessional Application with Excel Throughout the MBA program, you will have multiple opportunities to work with Excel using discipline-specific tools. Beyond learning to analyze data, it is crucial to apply findings for practical situations. Combining data, economic theory, and research provides hands-on practical