This is a pretty short assignment, I’m just not sure to do it. It involves using data in excel as well as python to make a chart.
Use the excel sheet provided for these
TASK 1: DATA QUALITY
Generate/build a descriptive statistics from your dataset: Mean; Standard Error; Median; Mode; Standard Deviation; Sample Variance; Kurtosis; Skewness; Range; Minimum; Maximum; Sum; Count; and Confidence Level(95.0%). (Create a separate sheet in the excel provided)
Task 2:
Using this link https://trinket.io/glowscript/756cf6efd5 to make an exponential chart graph from your dataset.
Please change the variables in the Python. Round off values in two decimal places. Press Run to graph the values. Use a snipping tool to capture (copy) the graph generated and paste in your excel sheet (Create a separate sheet in the excel provided)
TASK 3: FORECASTING
Watch (Links to an external site.)
” and then apply the forecasting techniques in Excel using your dataset. Attach to the Excel file (Create a separate sheet in the excel provided)
