Community Profile

photo

Tushar Agarwal


Active since 2016

Statistics

  • Thankful Level 3
  • First Answer

View badges

Content Feed

View by

Answered
Problems while exporting the data to excel file from MATLAB.
Hello - the conversion is probably due to the fact that excel has a different starting timestamp in its history, and Matlab I th...

7 years ago | 0

Question


Missing values - Running average
First of, I hvae this huge dataset, with 84000 rows and 24 cols. However, there are missing data cells within this excel file. M...

7 years ago | 2 answers | 0

2

answers

Question


Plotting a line which would include 95% of points above and below the regression line
Hello, I have used the segmented regression method to plot linear lines over my scatter plot. Now I want to draw a line paral...

7 years ago | 1 answer | 0

1

answer

Question


How to calculate the correlation between 4 variables in a matrix
Hello, I have a matrix with 4 variables. I want to find out the correlation of each variable with one another - so I used corr f...

7 years ago | 1 answer | 0

1

answer

Question


Find the point of the polyfit curve intersecting the x axis
Hello, I used the polyfit function to generate a slope across my 2d data points. However, I want to store the value of x, at ...

7 years ago | 1 answer | 0

1

answer

Question


Calculating daily Average if only, the value is not zero
Hello, I have a dataset, which I have been working on past few weeks.It has solar radiation hourly values(one column of 8760 ...

7 years ago | 3 answers | 0

3

answers

Question


Working and non Working hours
Is there a way in which I can split my data with one column having datetime (day and hour) into working and non working hours? ...

7 years ago | 1 answer | 0

1

answer

Question


Combining a Datetime matrix (8760 x 1) with another cell matrix (8760 x 2)
Hello, I have a data set of (8760 x 3)wherein a extracted just the first col of the data( in this format 'uuuu-MM-dd''T''HH:mm:...

7 years ago | 1 answer | 0

1

answer

Question


Daily average of 24 hours, for a year of data
Hi, I have a data sheet of 8760 hours, and another col of 8769 electrical values - and I wanted to cummulate every 24 hours ...

7 years ago | 2 answers | 0

2

answers

Question


How can i develop a Regression line with a confidence level bracket around this line?
I have a data set of temperature and energy use. Temp Energy I wanted to draw a scatter plot (which i could),and find ...

7 years ago | 1 answer | 0

1

answer