D2lpdx

1/26/2019 Quizzes - CE-112-001: CEE COMPUTATIONS (Winter 2019) - Portland State University

https://d2l.pdx.edu/d2l/lms/quizzing/user/attempt/quiz_start_frame_auto.d2l?ou=730256&isprv=&drc=0&qi=180208&cfql=0&dnb=0 1/4

Question 1Question 1 (0.5 points)

Question 2Question 2 (0.5 points)

Open the L4_quiz.xlsx file found in the Lecture 4 folder on D2L. The final contains the mean month air temperature data for Portland from 1880 through 2017.

Create repetition in the data using one of the rounding functions you have learned to group the data by decades. For example 1883 is in the decade 1800s, while 1897 is in the decode 1890s.

Create a pivot table that answers the following questions.

For the month of June in during the 1930s, what was the average monthly temperature?

Knowing that the temperature data is in Celsius and using the Pivot Table that you created in Problem 1, in what years does it appear that there is an error with the data?

To receive full create for this problem, you must select all answers that apply.

After you answer this question, removed the data values from you original data that are in error and refresh your Pivot Table.

a) 17.21

b) 17.32

c) 17.35

d) 17.53

1/26/2019 Quizzes - CE-112-001: CEE COMPUTATIONS (Winter 2019) - Portland State University

https://d2l.pdx.edu/d2l/lms/quizzing/user/attempt/quiz_start_frame_auto.d2l?ou=730256&isprv=&drc=0&qi=180208&cfql=0&dnb=0 2/4

1900

1901

1902

1903

1904

1905

1906

1907

1908

1909

1970

1971

1972

1973

1974

1975

1976

1977

1/26/2019 Quizzes - CE-112-001: CEE COMPUTATIONS (Winter 2019) - Portland State University

https://d2l.pdx.edu/d2l/lms/quizzing/user/attempt/quiz_start_frame_auto.d2l?ou=730256&isprv=&drc=0&qi=180208&cfql=0&dnb=0 3/4

1978

1979

2000

2001

2002

2003

2004

2005

2006

2007

2008

2009

2010

2011

2012

2013

2014

2015

1/26/2019 Quizzes - CE-112-001: CEE COMPUTATIONS (Winter 2019) - Portland State University

https://d2l.pdx.edu/d2l/lms/quizzing/user/attempt/quiz_start_frame_auto.d2l?ou=730256&isprv=&drc=0&qi=180208&cfql=0&dnb=0 4/4

Question 3Question 3 (0.5 points)

Question 4Question 4 (0.5 points)

After completing Problem 2, which 3 consecutive month periods had the highest average temperature for the years considered. (Hint: use the Grand Total row).

After completing Problem 3, determine the number of month during the period from 1880-2017 that the average monthly temperature was above 10 degrees

2016

2017

a) May-June-July

b) June-July-August

c) July-August-September

d) August-September-October

a) 1014

b) 642

c) 975