Calculate daily data using equation

Hi, I am just beginner for using Matlab. I have 2 matics as followings;

A = [col1]=Year, [col2]=Month, [col3]=Day, [col4]=Data1, [col5]=Data2, with dimension 365x5

B = [col1]=Month, [col2]=Coeff1, [col3]=Coeff2, with dimension 12x3

I would like make the equation using loop function to calculate mean monthly data daily by using data from A multiplied by coefficient value in matric B (data1 x coeff1 and data2 x coeff2). But I got some problem because data in B is monthly value and data in A is daily value. Is there anyone can help me about this matter?

[Star Strider]

Use the save function to save your matrices as a ‘.mat’ file, then use the ‘paperclip’ icon to upload them here.

We cannot help you write the code without being able to work with your data.

Answer 1

[Walter Roberson]

If you have R2016b or later, consider using a timetable and retime()