Olsen Company made 12 independent times studies in the hand paint spraying section of the finishing department. The following data where collected. Study no. Product surface area(in^2) Standard time(min) 1 170 0.32 2 20 0.1 3 151 0.31 4 35 0.14 5 115 0.27 6 41 0.16 7 143 0.29 8 104 0.24 9 95 0.21 10 87 0.2 11 120 0.27 12 31 0.12 How much spray time would you allow for a new part with a surface area of 195 in2? Write your answer to 4 decmial places.

I need help to find R^2 and Press final answers. Everything needed is attached also the contribution data.

Assignment: Analyze Filling Line Problems Using Control Charting Attached Files: File Filling line example for X-bar & control chart.xlsxOpen this document with ReadSpeaker docReader (13.354 KB) Using the provided data, calculate the control limits (X-bar and r-chart, Capability Index, create a control chart, and calculate the percentage of units that are expected to be out of spec (z-value). Show your work A quick way to do the percents part of the filling line problem (you know, the percent underfilled, the percent overfilled, etc.), is to use Excel's norm.dist function rather than looking it up on a printed Z table. Use the norm.dist excel function with the LSL in the first position in the parameter list. Norm.dist gives you the left side return from the Z table. "Excel offers you the NORM.DIST statistical function for working with normal distributions. The NORM.DIST function calculates the probability that variable X falls below or at a specified value"…

Please round to 5 decimal places