Categories
GB 513 Unit 1 Assignment
$6.00

GB 513 Unit 1 Assignment

This Tutorial was purchased 3 times & rated B+ by student like you.

 

This Tutorial contains following Attachments

  • GB 513 Unit 1 Assignment Questions.docx

This assignment requires you to use Excel to answer the questions and create the charts. However when presenting reports in business, you will find that most managers will prefer to read Word® documents or PowerPoint® slides rather than go through Excel sheets. Being able to move your work from Excel to Word® is a valuable skill. For this assignment, you should copy all your charts and comments to a Word document and submit that Word file. Clearly label all questions and charts, as well as your answers.

Question 1

According to T-100 Domestic Market, the top seven airlines in the United States by domestic boardings in a recent year were Southwest Airlines with 81.1 million, Delta Airlines with 79.4 million, American Airlines with 72.6 million, United Airlines with 56.3 million, Northwest Airlines with 43.3 million, U.S. Airways with 37.8 million, and Continental Airlines with 31.5 million. Construct a pie chart and a bar graph to depict this information.

Question 2

The U.S. Department of the Interior releases figures on mineral production. Following are the 15 leading states in nonfuel mineral production in the United States in 2008.

State Value ($ billions) Arizona 7.84
Nevada 6.48
Florida 4.20

Utah 4.17 California 4.00 Texas 3.30 Minnesota 3.21 Alaska 2.74 Missouri 2.08 Colorado 2.05 Michigan 2.05 Wyoming 1.89 Georgia 1.85

New Mexico 1.81 Pennsylvania 1.68

a) Using the data analysis toolpak in Excel, calculate the descriptive statistics.
b) Briefly explain what each of the metrics in the summary statistics means.
c) Commentonthefiguresinthereport.Whataretheytellingyouaboutthisdataset?Isit

symmetrical, flat, skewed, does it have outliers, and so on?

Question 3

Suppose Procter & Gamble sells about 20 million bars of soap per week, but the demand is not constant, and production management would like to get a better handle on how sales are distributed over the year. Let the following sales figures given in units of million bars represent the sales of bars per week over one year. Construct a histogram to represent these data. What do you see in the graph that might be helpful to the production (and sales) people?

17.1 17.1 17 25.2 19.6 12.2 18.3 26.3 15.4 19.9 13.6 23.9 17.4 18.7 39.8 30.6

15 20.4 20.7 25.2 18.5 20.3 21.3 26.2 20.6 15.5 22.5 26.9 18.4 16.8 21.4 32.8

20 19.1 23.4 26.3 20.9 20.4 23.1 26.6 19.3 15.4 22.8 24.3 18.2 20.3 21.4 26.2 14.7 17.5 24 23.8

Write a review

Order Id


Order Id will be kept Confidential
Your Name:


Your Review:
Rating:   A   B   C   D   F  

Enter the code in the box below:



Related Tutorials
$8.00

This Tutorial was purchased 6 times & rated B+ by student like you.

This is your final project. You will prepare a PowerPoint presentation to present your findings. This assignment requires you to use Excel; make sure you also submit the Excel file to show your work. Place all calculations for each of the questions on a separate worksheet. Then, using the resul..
$6.00

This Tutorial was purchased 5 times & rated No rating by student like you.

Question 1 Determine the error for each of the following forecasts. Compute MAD and MSE. Period Value Forecast Error 1 2 3 4 5 6 7 8 9 10 11 Question 2 202— — 191 202 173 192 169 181 171 174 175 172 182 174 196 179 204 189 219 198 227 211 ..
$6.00

This Tutorial was purchased 10 times & rated A+ by student like you.

Question 1 Shown below are rental and leasing revenue figures for office machinery and equipment in the United States over a seven-year period according to the U.S. Census Bureau. Use these data to run a linear regression and then forecast the rental and leasing revenue for the year..
$6.00

This Tutorial was purchased 1 times & rated No rating by student like you.

Question 1 A group of investors wants to develop a chain of fast-food restaurants. In determining potential costs for each facility, they must consider, among other expenses, the average monthly electric bill. They decide to sample some fast-food restaurants currently operating to estimate th..
$6.00

This Tutorial was purchased 1 times & rated No rating by student like you.

Question 1 An Adweek Media/Harris Poll revealed that 44% of U.S. adults in the 18–34 years category think that “Made in America” ads boost sales. A different Harris Interactive poll showed that 78% of U.S. adults in the 18–34 years category use social media online. Suppose that 85% ..
$25.00

This Tutorial was purchased 3 times & rated A+ by student like you.

GB 513 Unit 1 Assignment Questions GB 513 Unit 2 Assignment Probability GB513 Unit 3 Assignment GB 513 Unit 4 Assignment GB 513 Unit 5 Assignment GB 513 Unit 6 Assignment Final Project Colonial Broadcasting Case ..