EXCEL Assignment

User Generated

Znk417

Business Finance

Abraham Baldwin Agricultural College

Description

Unformatted Attachment Preview

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
Explanation & Answer:
1 Excel Sheet
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Attached.

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 squ...

Similar Content

Related Tags