I need help with a data analysis practice test spreadsheet. I have 6 problems to solve and I'm looking for help to learn how to solve them in the most effective way. I have worksheets of data showing energy generation from a solar farm and I must preform tasks with the data. The tasks include:
- Calculate sum of energy per day
- Calculate operating hours
- Convert 1 minute data into 5 minute data and then into 15 minute data
- Calculate the availability of inverters
- Calculate energy total from each inverter
Thank you for your help.
Solved by X. C. in 28 mins