Determine the mid-point value

Assignment Help Computer Engineering

Reference no: EM13240264

The following problem description will form the basis for all four assignments to be completed this trimester. Each assignment will require a different method to solve the same problem.

You will solve the problem using:

Spreadsheets
Pseudocode
C programming
Matlab programming

Problem Description

You are working as an Engineer for a materials manufacturing research lab and have been asked to provide an automated solution to analyse data.

The data relates to a new material being developed. The data is a measure of strength recorded every 100mm of the material and is stored in a file.

Each line in the file represents a row of measurements on the material. Data is separated by a comma ','.

EG: Contents of data.csv

0.999200,0.995130,0.908320,0.941690,0.938320,0.975690,0.958640,0.906410,0.916720,0.996150,0.909740,0.970470,0.940700,0.910230,0.907980,0.938310,0.946780,0.945750,0.950340
0.961300,0.945870,0.980420,0.950750,0.932500,0.941710,0.935300,0.945250,0.936680,0.946850,0.918760,0.934050,0.980840,0.914810,0.905720,0.938130,0.989400,0.936770,0.980560
0.997600,0.963490,0.973340,0.942630,0.992560,0.932970,0.931900,0.907730,0.907480,0.977110,0.914900,0.998710,0.977420,0.976050,0.984400,0.997990,0.955560,0.905830,0.950600
0.921240,0.931090,0.961080,0.980230,0.917860,0.957610,0.988320,0.926350,0.916860,0.901390,0.913380,0.934990,0.966200,0.988270,0.933500,0.960410,0.926740,0.942910,0.974440

The analysis is designed to determine if the sheet manufacturing process is producing sheets of the material to the accepted specifications.

The analysis required on the data is as follows.

Mid-Point Map

Determine the mid-point value (the value directly half-way between the max and the min) for each row and column of data. Note that the mid-point value is not the Median, nor the Mean.

For example with a data set of: 3 2 6 8 7

Our max value is 8, and our min value is 2. Therefore our mid-point value would be 5 (which is the value directly between the max and the min).

Create and display a Mid-Point Map that represents the value for each row and column as follows:

If the value for a cell in each row is less than the mid-point value for the row and column, display -1
If the value for a cell in each row is greater than the mid-point value for the row and column display 1, otherwise display 0
Calculate and display the count for the values 1, 0 and -1 for each row and column

Attachment:- Data.rar

Reference no: EM13240264

Questions Cloud

Find the maximum weight for the car : Find the maximum weight for the car if the springs should be compressed no more than 4.2 cm when the car is at rest

Create a probability distribution table and a cumulative : If you choose 12 vehicles at random, what is the probability that more than half(that is, 7 or more) carry just one person?)create a probability distribution table and a cumulative distribution.

A manufacturer of small appliances purchases coffeepot : A manufacturer of small appliances purchases coffeepot handles from an outside vendor. If a handle is cracked, it is considered defective and can't be used

Find the magnitude of potential difference between plates : Two parallel plates, each of area 7.00 cm^2, are seperated by 3.50 mm of water, What is the magnitude of the potential difference between the plates

Determine the mid-point value : Analysis is designed to determine if the sheet manufacturing process is producing sheets of the material to the accepted specifications and determine the mid-point value (the value directly half-way between the max and the min) for each row and col..

The researcher wishes to be accurate within 2% of the true : A researchers wish to estimate, with 95% confidence, the proportion of people who own a home computer. A previous study shows the 40% of those interviewed had a computer at home.

State what is g for the reaction at the specific temperature : At 700 K, the equilibrium constant for the reaction CO(g) + H2O(g) ? CO2(g) + H2(g) is 5.10. What is G for the reaction at the specific temperature

You tested to see if there is a need to use those additional : You are conducting a study on what socio-demographic factors could be behind the behavioral problems of students. You are looking at how many times a student was sent to detention. You have information on race, gender, household median income, single..

Find the magnetic moment of the rotating disk : A circular plastic disk of radius R, carrying a surface charge density? = ks, is rotating at constant angular velocity, Find the magnetic moment of the rotating disk

User Account

All Pages