Question

The following is an Excel question:

The Met Service would like a model to help keep track of some simple statistics. You will build a table for the month of January with 31 days. In a single column, enter the numbers 1 through 31 to serialise the days in the month. In the next column, enter the highest temperature (in Fahrenheit) recorded for each day during the month. You can simulate arbitrary values for these temperatures. In the next column, record the weather as Sunny, Cloudy, Rain or Snow arbitrarily again - you can have snow at a 100 deg Fahrenheit - no issue. Once you have simulated the values, just copy one set and use them and simulation can stop. The actual values in the table are immaterial.

Compute the following:
(a) Average Temperature for January
(b) Highest Temperature for January
(c) Number of Sunny Days
(d) Number of Days above 50 degrees Fahrenheit

(e) Average Temperature of Rainy Days
(f) Highest Temperature of a Rainy Day

(g) The day of month of January with the Highest Temperature – provide your answer in
the format “dd-mmm”.
(h) Second Highest Temperature of January
(e) Average Temperature of Rainy Days
(f) Highest Temperature of a Rainy Day

Show ALL FORMULAS used in the getting the answer.

Answer 1

Solution:

ANKITA BOSE ANKITA ROSE - - O OS: Hile Home Insert Page Layout Formulas Data Review A Show Querics L E From Table P From From From From Other Existing New Access Web Text Sources Connections Query- Recent Sources Get External Data Get & Transform HS - X -AVERAGE(84:834) Book1 - Excel View Help Tell me what you want to do Connections 24 Y clear IS roperty Sort Reapply Filter Text to All I dit links Advanced Columns Connections Share Data Analysis Flash Remove Data Till Duplicates Validation Data Tools → o be in Consolidate Relationships What If Forecast Group Ungroup Subtotal Analysis - Sheel - Forecast Outline Sort & Fiter Analysis A Η L J K L M N O P Q - | 46.32258 (a) Ave Temp. of January (5) Highest Temp. of January (c) No. of Sunny Days (d) No. of Days above 50 degree (f) The day of month of January with the Highest Temperature 12 25-Jan Ilighest Temp (in rl Weather Cloudy Cloudy Cloudy Rainy Cloudy Snow Snow Cloudy Cloudy Cloudy Rainy Rainy Cloudy Cloudy Rainy Rainy Sunny Sunny Sunny Rainy Sunny Sunny Rainy Sunny Sunny Sunny Sunny Nab 30 27 Sheet1 Reacy # 2 - + 100% Type here to search Ow! 9 R ON ADSENG 03:21 PM INIL 18-02-202019

ANKITA BOSE ANKITA ROSE - - O Share Dela Analysis Book1 - Excel View Help Tell me what you want to do Connections A Y clear Refresh Reapply Text to All I dit links Advanced Columns Connections IS OS: Hile Home Insert Page Layout Formulas Data Review Show Queries From From From From Other Existing New Access Web Text Sources Connections Query- Recent Sources Get External Data Get & Transform H6 - X V -MAX/84:834) A B C D E Properties Sort Filter - Flash Remove Data Till Duplicates Validation Data Tools - F i Consolidate Relationships What If Forecast Group Ungroup Subtotal Analysis - Sheel - Forecast Outline Sort & Fiter Analysis A F Н I J K L M N O P Q - 3 Day 4 1 5 2 46.32258 551 (a) Ave Temp. of January (5) Highest Temp. of January (c) No. of Sunny Days (d) No. of Days above 50 degree (f) The day of month of January with the Highest Temperature 25-Jan Ilighest Temp (in rl Weather Cloudy Cloudy Cloudy Rainy Cloudy Snow Snow Cloudy Cloudy Cloudy Rainy Rainy Cloudy Cloudy Rainy Rainy Sunny Sunny Sunny Rainy Sunny Sunny Rainy Sunny Sunny Sunny Sunny Nab 30 27 Sheet1 Reacy # 2 - + 100% Type here to search Ow! 9 R ON ADSENG 03:21 PM INIL 18-02-202019

ANKITA BOSE ANKITA ROSE - - O Share Data Analysis A Properties OS: Book1 - Excel Hile Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do 2. Show Queries Connections 24 Y L E clear E From Table From From From From Other Existing New Reapply Refresh Edit link o t Filter Text to er Recent S Text Acces Web Source - Connections Advanced Columns Get External Data Get & Transform Connections Sort & Fiter H2 - X f x -COUNTIFC4:C34, "Sunny") A B C D E F Z Sort Filter → o b Consolidate Relationships What If Forecast Group Ungroup Subtotal Analysis - Sheel - Forecast Outline t Flash Remove Data Till Duplicates Validation Data Tools Avanced Colum Analysis A H I J K L M N O P Q 4 5 1 2 46.32258 (a) Ave Temp. of January (5) Highest Temp. of January (c) No. of Sunny Days (d) No. of Days above 50 degree (f) The day of month of January with the Highest Temperature 25-Jan Ilighest Temp (in rl Weather Cloudy Cloudy Cloudy Rainy Cloudy Snow Snow Cloudy Cloudy Cloudy Rainy Rainy Cloudy Cloudy Rainy Rainy Sunny Sunny Sunny Rainy Sunny Sunny Rainy Sunny Sunny Sunny Sunny Nab 30 27 Sheet1 Reacy # 2 - + 100% Type here to search Ow! 9 R ON ADSENG 03:21 PM INIL 18-02-202019