Conversion formula creation assistance

Click For Summary

Discussion Overview

The discussion revolves around creating a conversion formula to translate frequency measurements from a mass air flow sensor, expressed in hertz, into mass flow rates in grams per second. The context includes the use of sample data points that may contain inaccuracies.

Discussion Character

  • Exploratory
  • Technical explanation
  • Mathematical reasoning

Main Points Raised

  • One participant, Cad, presents a dataset of mass flow rates in grams per second alongside corresponding frequency measurements in hertz, seeking assistance in formulating a conversion equation.
  • Another participant suggests plotting the data to visualize the relationship between the two variables.
  • Cad confirms they have created a graph in Excel but expresses uncertainty about the next steps in the analysis.
  • A later reply recommends adding a linear trend line to the graph and using the resulting formula as a potential model for conversion.

Areas of Agreement / Disagreement

Participants generally agree on the utility of visualizing the data through plotting, but the discussion remains unresolved regarding the specific method for deriving the conversion formula.

Contextual Notes

Some data points may be inaccurate by a few percent, which could affect the reliability of the resulting formula. The discussion does not address the implications of these inaccuracies on the conversion process.

Cadbury204
Messages
3
Reaction score
0
Hi,

I'm working on a project that uses a mass air flow sensor. It outputs a signal in hertz which relates to grams per second.

I am trying to create a formula that I can use to easily convert the Hz to G/s.

I have only been able to get a few samples of information to assist in the creation of the formula.

Is it possible to generate a formula from these data points?

Note: some of this data may be off by a few percent.

G/s Hertz
0 1700
2.75 4300
5.8 5680
3.97 4880
3.7 4800
6 5800
10.2 7150
12.4 7800
2.8 4300
3.1 4500
2.75 4300
13.53 8200
15.6 8800
22 9800
26 10500
28 11000
35 12100
44 13000

Any help is appreciated

-Cad
 
Physics news on Phys.org
Have you tried plotting this data?
 
I have put it into a graph in excel. But I'm not to sure where to go from here.

http://gi161.photobucket.com/groups/t208/O8ECKS3D6V/Untitled.png



-Cad
 
A good start would be to add a linear trend line, use the formula for the trend line as your model.