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

An important aspect of a change management strategy is to consider how different alternatives may impact future outcomes. Organizations often use the

An important aspect of a change management strategy is to consider how different alternatives may impact future outcomes. Organizations often use the business case method to explore strategic alternatives as it helps simulate a real situation. Such simulations help with identifying business issues and provide critical information that organizations can

Module 1 – CasePersonality and MotivationAssignment OverviewApplying Motivational Theories Herzberg posits that motivation is influenced by hygiene

Module 1 – CasePersonality and MotivationAssignment OverviewApplying Motivational Theories Herzberg posits that motivation is influenced by hygiene factors (which can demotivate if absent) and motivators (which can boost satisfaction when present). You will provide insights into motivation for a multi-generational workforce. Using the framework of McGregor’s Theory X and Theory

Module 1 – CasePersonality and MotivationAssignment OverviewApplying Motivational Theories Herzberg posits that motivation is influenced by hygiene

Module 1 – CasePersonality and MotivationAssignment OverviewApplying Motivational Theories Herzberg posits that motivation is influenced by hygiene factors (which can demotivate if absent) and motivators (which can boost satisfaction when present). You will provide insights into motivation for a multi-generational workforce. Using the framework of McGregor’s Theory X and Theory

ListenMBA 620 Project Guidelines and RubricCompetencies In this project, you will demonstrate your mastery of the following competencies:Prepare and

ListenMBA 620 Project Guidelines and RubricCompetencies In this project, you will demonstrate your mastery of the following competencies: Prepare and present internal and external reports. Monitor and evaluate performance. Recommend opportunities for performance improvements. Scenario You are a former pilot, and you are now the controller of a division of

MBA 580 Project Guidelines and RubricCompetencies In this project, you will demonstrate your mastery of the following competencies:Evaluate creative an

MBA 580 Project Guidelines and RubricCompetencies In this project, you will demonstrate your mastery of the following competencies: Evaluate creative and innovative organizational structures Recommend alternative innovations to solve an internal or market need Implement creative and innovative processes within an organization Overview Companies that are innovative must make sure