Community Profile

photo

Ann


Last seen: 2 years ago Active since 2020

Statistics

  • Knowledgeable Level 1
  • Thankful Level 3
  • First Answer

View badges

Content Feed

View by

Question


Calculate standard deviation with different time interval
Good day, everyone. Dummy_Raw.xlsx is a spreadsheet that contains data for each minute of a 24-hour period. I would like to cal...

2 years ago | 1 answer | 0

1

answer

Question


Combine two excel files with different row and column lengths into one excel file
Good day, everyone. Attached are two excel files that I plan to combine the selected data into one excel file. From Dummy_A,...

2 years ago | 2 answers | 0

2

answers

Question


2D line plot xy with color from z variable
Hi everyone, I have an abundance of data in excel (556873 rows). Data can be get here Data 365 days . x=TIME, y=S4, z=PRN. I ...

3 years ago | 3 answers | 0

3

answers

Question


Display image with 3 variable from abundance of excel data.
Dear community, My data as attached is in every minute in every day of January 2014 from 31 different of observer (PRN). My var...

3 years ago | 1 answer | 0

1

answer

Question


Plot with color variation from third variable
Hi, everyone. My data have three variables which are Time (x-axis), S4 (y-axis) and PRN. I'm trying to plot the data color acco...

3 years ago | 1 answer | 0

1

answer

Question


Calculate the rate of change from 5 minutes interval
Good day, everyone. As attached is my observations data for 24 hours from different transmitter (PRN) . The data here are from ...

3 years ago | 2 answers | 0

2

answers

Answered
XLSread - multiple sheets
Hi, Pratha. I'm not sure if it helps or not because I also have similar situation with you but my parameter can combine in one ...

3 years ago | 0

| accepted

Question


Calculate standard deviation of 5-minute for different time interval
Hi, everyone. Here I attached my observations data on 1-31 of January 2014 for 24 hours from different transmitter (PRN) . By t...

3 years ago | 1 answer | 0

1

answer

Question


Calculate minutes average values
Hi, everyone. As attached is my observations data for 24 hours from different transmitter (PRN) . The data here are from 1/1/20...

3 years ago | 1 answer | 0

1

answer

Question


Plotting best fit line
Hi everyone, This is my coding and the figure below is the result. My data are all in excel file but now I don't know how to pl...

3 years ago | 1 answer | 0

1

answer

Question


Long runtime when producing the graph
Hi. I’m new here. I’m working with importing data from MS Excel and make it in a almost a thousand lines of coding. Because I...

3 years ago | 0 answers | 0

0

answers