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