[SOLVED] 代写 graph Data Project – Chapter 2

Data Project – Chapter 2
Describe Your Data
Download the Excel file with the data from Moodle.Complete the following steps in one tab of the Excel workbook. Save the file for the next portion of the project. You will submit the final project at the end of the semester.
Instructions
•Construct a Histogram for each of the data sets.
•The horizontal axis will be the rate
•The vertical axis will be the frequency.
•It is up to you how you want to break up the interest rates into classes on the horizontal axis.For example, you could use 4.1 to 4.5 or 4.01 to 4.25. But the class widths should be no larger than 100 basis points.

•Construct a time series graph for each data set.

•Calculate the mean, median and mode for each of the data sets.

•Calculate the range, standard deviation and variance for each data set.

•Convert each data value to a z score.

•Construct a box plot for each data set and identify any outliers.

•Plot the two data sets on one graph using the Fed Funds rate as the horizontal axis and the Prime rate on the vertical axis.Each point will be one date with two rates.Is there a trend?