Analyze statistics about visitation to national park service

Assignment Help Applied Statistics
Reference no: EM131038255

Project: NPS Visitation Problem

Project Description: Students will analyze statistics about visitation to National Park Service units in the eastern United States.

Instructions

1 Start Excel. Open the downloaded Excel workbook named NPS_Visitation.xlsx.

2 Format cells A3 through N184 as a table using a style of your choice.

3 We need to add an additional table column to store average visitation statistics on the Visitation sheet.

Insert one new table column to the right of existing column N.

4 For the table, turn on the Total Row option.

5 Enter text in the cell as indicated below:

O3: Average

6 Merge-and-center cells A1 through O1.

7 Apply the Title cell style to cell A1.

8 Format the cells as indicated below:

D4 through O185: number with no decimal places, use 1000 separator

9 In column O, use the AVERAGE() function to determine the average number of visitors to each NPS unit from 2003 to 2013.

10 In the total row, individually find the sums for columns D through N.

11 In the total row, do not display any statistics in column O.

12 AutoFit the widths of columns A through C. Set the widths of columns D through O to 11.

13 Create a 2-D line chart based on the non-contiguous cell range A3, D3 through N3, A185, and D185 through N185 of the Visitation sheet. Move the chart to a new sheet named Total Visitation Chart.

Ensure that the years are shown as labels for the horizontal (category) axis, not plotted as chart data. Specify appropriate chart and axis titles.

14 Add a trendline to the Total Visitation Chart based on the total visitation. Use the trendline type that best fits the data and project the values forward 10 periods (through the year 2023). Display the R-squared value on the chart.

Note: You cannot use the Moving Average type for your trendline.

15 Create a new PivotChart and PivotTable based on the data in cells A3 through O184 of the Visitation sheet. Place the PivotTable on a new sheet named Visitation PivotTable and move the PivotChart to a new sheet named Visitation PivotChart.

16 On the PivotTable, do the following:

- Add the park type as a Rows field.
- Add the average visitation as a Values field.

17 On the PivotTable, summarize the average visitation figures by summing them.

18 Format the PivotTable cells as indicated below:

- Visitation column: number with no decimal places, use 1000 separator

19 We need to perform some formatting on our PivotChart.

- Ensure the chart is a 2-D clustered column chart.
- Specify appropriate chart and axis titles.
- Turn off display of the legend.

Attachment:- NPS_Visitation.xlsx

Reference no: EM131038255

Questions Cloud

How can existence of supply chain risk management efforts : Which comparable and comprehensive metrics have been required to assess supply chain resiliency capabilities? How can we relate these metrics to the Time-to-Recovery measurement for all capabilities?
Considering buying several franchises in fast-food business : You and your business partners are considering buying several franchises in the fast-food business. You are all experienced managers or entrepreneurs, but none of you has experience in franchising. Summarize how a search like this can assist you with..
Which type of organizational structure is best suited : Which type of organizational structure is best suited for developing a new product which requires a high level of specialization in several functions and the time to market represents a critical factor? A materials manager suspects that the quality o..
Consider in understanding and managing organizational change : Discuss how and why leadership may be significant to consider in understanding and managing organizational change. Base your discussion on an interpretative perspective of change processes. Discuss how and why leadership may be significant to conside..
Analyze statistics about visitation to national park service : Project Description: Students will analyze statistics about visitation to National Park Service units in the eastern United States.
Is one environment more important in driving strategy : Some like Michael Porter propose that strategy is driven mostly by the external environment. Review Porter’s Five-Forces Model and see if you agree. Is it mostly driven by external environment? In the other camp are the resource based view proponents..
Updated as the global business environment changes : Michel Porter of Harvard Business School has developed a tool for Strategic analysis known as Porter’s Five-Forces Model. What are its pros and cons as the tool of choice for strategic analysis? Is it complete or are there pieces missing? Is it timel..
What are the pros and what the cons : Why do companies have the conversion condition? What are the pros and what the cons? Identify which pro you consider to be most advantageous and which con you think is the most detrimental or negative. Explain.
Compare the economic policies for health promotion : Compare the economic policies for health promotion, wellness, and prevention programs in the United States and the country you selected. Include differences in approaches to wellness and prevention. Analyze implications of these policies and disparit..

Reviews

Write a Review

 

Applied Statistics Questions & Answers

  Find the minimum percentage of all possible daily demand

Find the expected demand. Interpret this value, and label it on the graph of part a. Using Chebyshev's Theorem, find the minimum percentage of all possible daily demand values that will fall in the interval [mx ± 2sx].

  A student scored 76 on a general science test

A student scored 76 on a general science test where the mean and standard deviation were 82 and 8, respectively he also scored 53 on a psychology test where the class mean and standard deviation were 58 and 3, respectively. In which class was his rel..

  Defined as the number of calculators

Rework problem 16 in section 4.1 of your text, involving drawing calculators from a box of working and broken calculators. Assume that the box contains 15 calculators: 13 that work and 2 that do not work. A sample of 5 calculators is selected and a r..

  Determining factors of gender identification and gender role

Determining factors of gender identification and gender roles.

  People call a suburban hospital''s health hotline

People call a suburban hospital's health hotline at the rate of eighteen per hour on Monday mornings; this can be described by Poisson distribution. Providing general information or channeling to other resources takes an average of three minutes per ..

  Business research report proposal

Identify a business research topic and define the research questions for the identified problem or opportunity

  Find a peer-reviewed article

Find a peer-reviewed article that provides an example of a study that utilized a t-test for a single sample (on a topic of interest to you). Briefly describe the study and discuss its findings.

  Keeps track of the number of complaints

A customer service center keeps track of the number of complaints received each day about one of their new products. The number of complaints received over the last 11 day period are 19, 18, 22, 21, 17, 18, 22, 19, 16, 23, and 25. The IQR for this sa..

  If a null hypothesis is rejected at a significance level of

The further the hypothesized mean is from the actual mean the lower is the power of the test. The manager of the quality department for a tire manufacturing company wants to know the average tensile strength of rubber used in making a certain brand o..

  Two types of cotton cloth-denim and corduro

Barrows Textile Mills produces two types of cotton cloth-denim and corduroy. Corduroy is a heavier grade of cotton cloth and, as such, requires 7.5 pounds of raw cotton per yard, whereas denim requires 5 pounds of raw cotton per yard. A yard of..

  The probability a judge acquitting a randomly

A study revealed that the probability a judge acquitting a randomly chosen defendant was 0.17 while the probability that a jury would acquit a randomly chosen defendant was 0.33. Further, the probability that both a judge and a jury would have ..

  What is the probability that the sample mean

1. Suppose we want to estimate the mean BMI for women in pregnancy at 20 weeks gestation. If we have a sample of 100 women and measure their BMI at 20 weeks gestation, what is the probability that the sample mean is within 1 unit of the true BMI if t..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd