CMPS 273 Assignment 6, Data Generation, Consistency, Smoothing, Due March 16; 160 points

For this assignment complete the work outlined below.

  1. Important data: (10)
  2. Name
  3. W number
  4. Use Excel to generate a data set with 200 points.
  5. The mean of the data is 50.
  6. Graph the data.
  7. Perturb the data points by a random amount between -5 and 5 about the mean.
  8. Calculate the following statistics from the data set.
  9. Average
  10. Standard deviation
  11. Variance.
  12. Use Excel to generate a data set with 200 points.
  13. The mean of the data is 50.
  14. Graph the data.
  15. Perturb the data points by a random amount between -20 and 20 about the mean.
  16. Calculate the following statistics from the data set.
  17. Average
  18. Standard deviation
  19. Variance.
  20. Use Excel to generate a data set with 200 points.
  21. The data is described by the following equation y = 1/3*x*x*x. Let x range from -100 to 99
  22. Graph the data.
  23. Perturb the data points by a random amount between -5 and 5 about the mean.
  24. Calculate the following statistics from the data set.
  25. Average
  26. Standard deviation
  27. Variance.
  28. Use a copy of the data from question 4 as a starting point for this question.
  29. Smooth the data using a window size of 3. Use a centered window, that is the current point is replaced by the average of itself, the previous point and the next point.
  30. Find the average, standard deviation and variance of this data set.
  31. Make another copy of the data and smooth it using a window size of 7.
  32. Find the average, standard deviation and variance of this data set.
  33. Compare your answers from a and b. Which is smoother, why?
  34. Calculate the weighted average of the following number sets. Let the first number and last number each be weighted by 20 percent, let the others be equally weighted.
  35. 100 80 80 40 40 90
  36. 60 90 90 100 100 30
  37. 80 80 80 80 80 20
  38. 90 60 60 70 50 100

2