Scribd
Upload
28 views1 page

Statistical Analysis Assign1

The document provides instructions for an assignment involving statistical analysis using Excel. It includes temperature data and asks to create a frequency distribution table, frequency polygon, and ogive. It also asks to find sales data for a company during the pandemic and create an appropriate graph to display the results.

Uploaded by

Ice Voltaire Buban Guiang
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
28 views1 page

Statistical Analysis Assign1

The document provides instructions for an assignment involving statistical analysis using Excel. It includes temperature data and asks to create a frequency distribution table, frequency polygon, and ogive. It also asks to find sales data for a company during the pandemic and create an appropriate graph to display the results.

Uploaded by

Ice Voltaire Buban Guiang
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

STATISTICAL ANALYSIS with Software Application

(AIS 05-19)

ASSIGNMENT #1

1. Below are the high temperatures (in degrees Fahrenheit) for the 30 days in September

80 68 84 86 85 77 64 81 93 94
97 93 89 82 76 75 83 90 83 84
92 94 90 92 91 84 81 84 79 90

Using MS Excel
a. Construct a frequency distribution table.
b. Draw a frequency polygon and Ogive

2. Business companies, as we all know, are affected with the ongoing pandemic. Get a
legitimate data from business magazines or newspapers that will show the lost (or even
gain) of sales of your choice company. Then, construct the appropriate graph to show
the data.

Submission will be on August 31, 2022 using NEUVLE.

You might also like