Predict power consumption using linear regression
4 views (last 30 days)
Show older comments
I want to predict power consumption per hour with this data using linear regression.
How can i do this?
0 Comments
Accepted Answer
Star Strider
on 28 Oct 2022
There are 89 days in the data, so the data ‘wrap’ to 24 hours.
T1 = readtable('https://www.mathworks.com/matlabcentral/answers/uploaded_files/1172328/data2022.csv', 'VariableNamingRule','preserve')
VN = T1.Properties.VariableNames;
nrDays = nnz(T1.time == 24)
mdl = fitlm(T1.time, T1.('power_consumption(MW)'))
[y,yci] = predict(mdl, T1.time);
figure
plot(T1.time, T1.('power_consumption(MW)'), '.')
hold on
plot(T1.time, y, '-r')
plot(T1.time, yci, '--r')
hold off
grid
xlabel(VN{1})
ylabel(strrep(VN{2},'_','\_'))
.
4 Comments
More Answers (1)
Florian Bidaud
on 28 Oct 2022
Hi,
You can use the function polyfit with x being the time and y being the power consumption, you will have to choose n to fit your data as you want. In your data, I guess when the time comes back to 1 it means it's another day ? Then you will need to change 1,2,3,..., 23 to 25,26,27,....47 for the second day and so on
0 Comments
See Also
Categories
Find more on Descriptive Statistics in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!