Explore BrainMass

Explore BrainMass

    developign a theory, collecting data, and using regressions.

    Not what you're looking for? Search our solutions OR ask your own Custom question.

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    For my project I plan to pull information from the State of California, Department of Agriculture on the nut crop yields. They have historical information on prior years yields. I also plan to pull a couple of other variables that impact yields like rainfall and acres planted. Using this historical information I want to be able to predict the yields for this year. The data can be for any type of produce I just picked nuts because it sounds kind of funny.

    My question is - once I have this data what formula's should I use as a predictor and at what confidence levels?

    Can someone tell me how to set-up the data and which formulas to use and what each formula means? And keep it as simple as possible.

    © BrainMass Inc. brainmass.com March 4, 2021, 9:39 pm ad1c9bdddf

    Solution Summary

    The following posting begins by collecting data on nut yield and rainfall in California to demonstrate a process of creating a theory to explain nut yield in California. Once the data is collected theories are proposed and functional forms are specified for a regression equation. Regressions are conducted in Excel.