Variable extraction

[MattLogue9]

I'm depressed so I can't read complex math equations clearly.. I got a problem. Trying to build an air quality monitoring system. I use array MOX MQ gas sensors so I have many inputs. I want gas identification and concentration. If it's one gas u just loop thru each gases linear function for each sensor.. the lowest STDDEV wins.

What if it's a mixture?

[Pepe Le Mokko]

Administrative note

Welcome to the forum

missed the yellow banner advising how to get answers faster by posting a sheet ?

Please take a moment to read it and attach a sheet accordingly.

Thanks you for helping us help you

[MattLogue9]

Administrative note

Welcome to the forum

missed the yellow banner advising how to get answers faster by posting a sheet ?

Please take a moment to read it and attach a sheet accordingly.

Thanks you for helping us help you

Sorry... My PC died and I needed adv statiticic help

[FDibbins]

Pepe is suggesting that you upload a sample workbook, so we can see what you have and what you want.

[MattLogue9]

Pepe is suggesting that you upload a sample workbook, so we can see what you have and what you want.

PC dead. Few errors I'm afraid. First column is a sensor that has varying sensitivity to a number of gases, sensors have a degree of cross-sensitivities.. 2nd column is m (slope), 3rd column b (y-int). Formula for ppm is y=e^b*x^m.
I'm emplyoying an array of them. I want to able to I'd gases and concns. One gas is trivial... Mixture as you usually encounter is NOT TRIVIAL.

I suck at calculous. I know basic stats, this is very advanced. Somebody did same thing using Principal Component Analysis, along with Feature Extraction, normalization, and recognition using values from an array of gas sensors. I simply can't understand article.

"Research on a mixed gas recognition and concentration detection algorithm based on metal oxide semiconductor olfactory system sensor array", by Xu, Zhao, Chen, & Zhao: Sensors, vol 18, 3264, 2018.

I'm depressed so can't think clearly and obsessed with getting this solved. I wish I could provide a better picture but PC power supply died.

2 1911.870504 2.046510581 Alcohol
2 -0.0002826429536 4.25520036 CO
2 -0.0001411301216 1.6 Hydrogen
2 -0.0001411301216 1.603552454 Hydrogen
2 -0.0001283205763 1.979063485 Methane
2 -0.0001158712292 2.046510581 Propane
3 -0.1429429429 1.475555556 Alcohol
3 -0.2477477477 3.183333333 Benzene
3 -2.657657658 42.83333333 CO
3 -3.363363363 41.77777778 Hexane
3 -2.987987988 38.72222222 Propane
4 -0.00006157136425 4.096533093 CO
4 0 0 Hydrogen
4 -0.0001489194057 2.155965781 Propane
4 0 0 Smoke
5 -0.0001647906348 3.2 Alcohol
5 -0.0001277577668 3.4 CO
5 -0.0000790859973 1.41525439 Hydrogen
5 0 0 Methane
5 0.0001003376857 0.5 Propane
6 -0.0003249662314 7.279873931 Alcohol
6 -0.0002349167042 8.510355696 CO
6 -0.0002655335434 4.657991896 Hydrogen
6 -0.0001661413778 2.2 Methane
6 -0.0001252588924 1.594299865 Propane
7 -0.001040972358 15.75230347 Alcohol
7 -0.0003082336797 1.3 CO
7 -0.0002481866301 0.9177808273 Hydrogen
7 -0.00150284258 14.39645168 Methane
7 -0.0006486963341 7.391972162 Propane
8 -0.001745159838 19.31526339 Alcohol
8 -0.0005511256191 5.230868978 Hydrogen
9 -0.00125 2.05 CO
9 -0.0001687303017 2.363259793 METhane
9 -0.0001354570014 1.652372805 PROpane
131 -0.04829073482 5.035447284 Chlorine
131 -0.06297124601 7.723801917 NO/NO2
131 -0.0307827476 3.13928115 Ozone
135 -0.1450184502 3.298523985 Ammonia
135 -0.08311808118 2.275553506 co?
135 -0.0778597786 2.771217712 CO2
136 0.003326923077 1.128846154 H2S
137 -0.004684501845 1.447398524 Ammonium Ion (NH3)
137 -0.009442804428 2.435756458 C2H6O?
137 -0.007474169742 2.775664207 CO