EXCEL Proficiency Check Assignment Instructions: Download the file. Save it on your course directory (create an EXCEL files subdirectory and save the fi Answer the questions below. Save the completed file and upload via assignment on CANVAS. Problem 1 Condsider the following data set. 23 27 Calculate average of the data= 29 Calculate standard deviation= 25 Calculate median of the data = 20 Find maximum value= 30 Find minimum value= 45 Find sum of the squares of each data= Problem 2 Consider the following data set Y X 3.3 105 3.2 115 3.4 94 3 93 2.8 78 2.9 79 2.7 67 2.6 62 2.5 57 2.6 45 2.2 55 2 36 2.3 30 2.1 19 Problem 3 Find the value of the sum of the product of each pair of numbers (x an Find the sum of the squares of each value of X= Find the square of the sum of the values of Y= Plot a scatter plot of X vs. Y here -----> Draw a straight line on the scatter plot that approximates the nature of the data Copy the above X and Y data below. Sort X from low to high and Y from high to low. Problem 4 A= Matrix 1 1 2 5 2 3 7 B= Find C = A x B Matrix 2 5 8 3 9 Write the matrix here C= Find inverse of Matrix C: Find determinant of Matrix C: Problem 5 write the column with header "New" where each number is the product of the first value of Y (3.3) and (the first number will be 3.3*105, next 3.3*115) Y X New 3.3 105 3.2 115 3.4 94 3 93 2.8 78 2.9 79 2.7 67 2.6 62 2.5 57 2.6 45 2.2 55 2 36 2.3 30 2.1 19 Also calculate the value of this expression using the Y vector above Y'Y - (Σyi)^2/n = where Y is the complete Y-vector and Y' is the transpose of the Y-vector. The size Problem 6 A machining process produces gears pitch diameter of which is normally distributed random variable with a mean of 55cm and standard deviation of 0.45 cm. The inspection process uses the type I (α) erro in-control/out-of-control decisions for the machining process. Periodically n gear samples are collected If the condition: NORMINV(α/2, 55, 0.45) ≤ x-bar ≤ NORMINV(1-α/2, 55, 0.45) is satisfied, the process i Calculate the limits using α value of 0.1. If the true process mean has shifted to 55.8 cm, what is the probability that the above process will still β-error = That the average of the n samples drawn from the shifted process with mean 55 Area of the normal distribution with mean 55.8 and std. de Hence β-error= β-error= NORMDIST(upper limit,55.8,0.45,TRUE) - N α= upper limit= Lower limit= beta error= 0.1
Purchase answer to see full attachment