please identify the steps i can Use to create the graphs and tables in

a blank Excel file and grouped frequency distribution of the maximum daily temperatures for the 50 states for a 30 day period. Use 8 classes.

help me to understand how to create as Add midpoint, relative frequency, and cumulative frequency columns to your frequency distribution.

steps to create a frequency histogram using Excel.

show me how to create.an ogive in Excel

Data Set

Maximum Temperatures by State

in the United States

for the month of August, 2013

State Name Max Temps in August 2013

AL 97

AK 97

AZ 45

AR 100

CA 49

CO 109

CT 93

DE 91

FL 102

GA 99

HI 90

ID 97

IL 97

IN 93

IA 100

KS 111

KY 93

LA 97

ME 93

MD 97

MA 97

MI 91

MN 109

MS 97

MO 97

MT 90

NE 108

NV 111

NH 93

NJ 108

NM 106

NY 93

NC 100

ND 88

OH 91

OK 108

OR 97

PA 93

RI 104

SC 97

SD 93

TN 99

TX 104

UT 106

VT 91

VA 102

WA 93

WV 91

WI 90

WY 99

need before 10 PM please