1. Answer the following questions based on the truck vibration data given in the following table. You may use Excel in your answer, but you must show sample calculations for full credit. Assume a band width of 1 Hz. a. Calculate the 30 peak acceleration at each frequency. What percent confidence do you have that the acceleration is less than or equal to this level? b. Plot the PSD on a log-log plot in Excel. c. Your packaged product has a peak magnification factor of 10 at an input frequency of 12 Hz. If your product will damage at anything above 20 g, do you expect the product to survive transport? Explain you answer. BPF Freq. (Hz) 2 Peak Accleration (g) 30 RMS Accel. PSD (RMS) (g?/Hz) 0.0020 0.0500 0.0200 0.0030 12 30 70 1. Answer the following questions based on the truck vibration data given in the following table. You may use Excel in your answer, but you must show sample calculations for full credit. Assume a band width of 1 Hz. a. Calculate the 30 peak acceleration at each frequency. What percent confidence do you have that the acceleration is less than or equal to this level? b. Plot the PSD on a log-log plot in Excel. c. Your packaged product has a peak magnification factor of 10 at an input frequency of 12 Hz. If your product will damage at anything above 20 g, do you expect the product to survive transport? Explain you answer. BPF Freq. (Hz) 2 Peak Accleration (g) 30 RMS Accel. PSD (RMS) (g?/Hz) 0.0020 0.0500 0.0200 0.0030 12 30 70