ExamGecko
Question list
Search
Search

List of questions

Search

Question 11 - Desktop Certified Associate discussion

Report
Export

Connect to the 'Life Expectancy at birth' data source, combine sheets Data_20th century and Data_21st century. Find the moving average for the average life expectancy for 10 years before 2000 and 10 years after 2000 for New Zealand.

A.
78.56
Answers
A.
78.56
B.
78.286
Answers
B.
78.286
C.
78.03
Answers
C.
78.03
D.
78.303
Answers
D.
78.303
Suggested answer: B

Explanation:

Connect to the 'Life Expectancy at birth' excel file, drag Data_20th Century sheet to the canvas. If you find data columns are not correct.

Use the data Interpreter, it will correct the data.

Select the column 1960 to 2000. And Click on the Pivot option

Rename the two new columns as 'Years' and 'Life Expectancy'

Create a Union by dragging the sheet Data_21st Century to Data_20th Century, once you see the orange block for union.

Now, select column 2001 to 2013 and Select Add data to Pivot.

Select Country and Country Name field, Merge these fields.

Rename the merged field as Country.

Let's create the view.

Drop the country to the Filters and Select New Zealand. Drop the years to the columns and 'Life Expectancy' to the Text marks card. Change the aggregation to Avg (it won't make a difference here).

Right-Click on Life Expectancy -> Quick Table Calc -> Moving Average

Again, right-click on it and edit the table calculation.

Update the values as:

Result is:

asked 23/09/2024
Paul Walker
41 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first