Required File:  Blank Excel Spreadsheet

Directions:

A company’s earnings for the 12 months in the current year were:

Jan. $100,000
Feb. $89,000
Mar. $78,000
Apr. $70,000
May $65,000
Jun. $72,000
Jul. $79,000
Aug. $85,000
Sep. $105,000
Oct. $125,000
Nov. $118,000
Dec. $108,000

(1) Graph the monthly earnings using a line graph.

(2) Graph the monthly earnings using a bar graph.

The earnings by quarter were:

First quarter: $267,000 about 24%
Second quarter: $207,000 about 19%
Third quarter: $269,000 about 25%
Fourth quarter: $351,000 about 32%

(3) Graph the quarterly earnings using a pie chart.