precision not align with excel calculation

[krispiekream]

my original question was 

how would i do an average of an array from 

index 100 to 300?

if i have an array of 2000 indexes,

how can i get the average from 100-300?

in 

excel it would be

=avg(C100:C300)

i did the same method in labview but my numbers dont come out right.

i am thinking that my setting is wrong with the precision of the format?

[altenbach]

remember that in LabVIEW the index of the first element is zero, while in excel the first index is 1. You are not comparing the exact same subset.

Set the start index to 99 in LabVIEW and see if things agree better.

[krispiekream]

yeah. i tried that too but it didnt come out right.

the last number is way off

[altenbach]

Place an indicator after array subset and compare the actual numbers. (e.g. first and last value in the range, etc.).

How do you read in the data?

(Why do you get the same column twice using index array. Get it once and branch the wire!)

[altenbach · Accepted solution]

You are also defining the ranges wrong.

In LabVIEW you give start index, number of elements. (you seem to wire the end index instead of the number of elements!)

[krispiekream]

oh!!

sorry..silly me. 

i wasnt thinking this morning. 

[krispiekream]

Hi altenbach

can you tell me if labview is capable of analyzing this data?

i took the average of 200 elements from 

100-300

400-600

700-900

1000-1200

1300-1500

1600-1800

thats because i have seen the graph and took the average of those points 
(manually)

is there any way labview can look through a column and take the average of the points BEFORE THE CHANGE in temperature?

[altenbach]

Yes, LabVIEW can do that. Have you tried?

[krispiekream]

i have been thinking about it for like a month.

i havent tried because IT just installed labview on my laptop like yesterday. 

can you guide me?

oh yeah..someone suggested signal procession controls but i dont have it installed in this evaulation version so that wont work. 

[Intaris]

---

@krispiekream wrote:

like a month.

like yesterday. 

---

Is that an approximate comparison or not?  Is a day like a month?  Is 30.5 days like a month?  Is four hours ago like Yesterday?

Seriously, you've been thinking about analysing the data with LabVIEW for like a month?  What ideas have you come up with so far?