Data visualization homework assignment

Assignment Help Operation Management

Reference no: EM131650067

Data Visualization Homework Assignment Using the Rig Count Data spreadsheet (see homework page for this module), do the following: 1. Create a pivot table and answer the following questions: a. In the first week of 2014, how many horizontal oil rigs were in operation in the Permian Basin? b. In the first week of 2014, how many horizontal oil rigs were in operation in the Permian Basin in Texas? c. Compare the ratio of vertical to horizontal drilling trajectory in New Mexico and Texas. In the first week of 2014, which state had a higher ratio of vertical drilling rigs? d. Explore. Try different combinations of fields in rows, columns and filters. What interesting observations can you make? 2. Create a pivot chart from the Rig Count Data for the first week of 2014. Do the following: a. Create a vertical bar chart that compares the drilling trajectories of oil rigs in Texas, New Mexico, and Oklahoma. b. Create a pie chart that indicates the oil rig count by geological location (basin). Exclude the “other” category from your chart. c. Experiment with other types of charts and combinations of fields.

The data table is too large for me to copy and paste. Any recommendations?

Reference no: EM131650067

Questions Cloud

Development of training courses would be challenging : Do you think the development of training courses would be challenging? Rewarding? Both? Explain.

How many teenagers smoke tobacco : Teen smoking 2006. The Centers for Disease Control and Prevention say that about 23% of teenagers smoke tobacco (down from a high of 38% in 1997).

How many students must be surveyed about alcohol abuse : Alcohol abuse. Growing concern about binge drinking among college students has prompted one large state university to conduct a survey to assess the size.

What responsibilities do external auditors have to notify : What responsibilities do external auditors have (under the Auditing Standards and Corporations law) to notify their clients about internal control weaknesses?

Data visualization homework assignment : Data Visualization Homework Assignment Using the Rig Count Data spreadsheet. Experiment with other types of charts and combinations of fields.

Report on recruitment in an industry or organisation : HRMT20024 Assessment Task - Report on Recruitment in an Industry/Organisation. Develop skills in analysing an organisational/industry environment

Which type of error would additive manufacturer consider : Errors. An auto parts company advertises that its special oil additive will make the engine "run smoother, cleaner, longer, with fewer repairs."

Believe is most important for patients : Which of the two statements above do you believe is the most important for patients?

What is the difference between a leader and a manager : What is the difference between a leader and a manager? Is it better for leaders to be respected or feared? Why?

User Account

All Pages