Community Profile # Tushar Agarwal

Active since 2016

#### Statistics

• • #### Content Feed

View by

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...

4 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...

4 years ago | 2 answers | 0

### 2

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...

4 years ago | 1 answer | 0

### 1

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...

5 years ago | 1 answer | 0

### 1

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 ...

5 years ago | 1 answer | 0

### 1

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 ...

5 years ago | 3 answers | 0

### 3

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? ...

5 years ago | 1 answer | 0

### 1

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:...

5 years ago | 1 answer | 0

### 1

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 ...

5 years ago | 2 answers | 0