Explore BrainMass

Explore BrainMass

    Data Analysis on Soft Drink Study

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

    Producing analysis as part of soft-drink industry study. Help with the following would be appreciated:

    a) Plot data
    b) Linear trend line (simple regression) and coefficient significance
    c) Quadratic trend line (Y=a+bt+ct2) and significance of coefficients
    d) Estimated exponential trend line . Values of a+b
    e) Calculate Mean Sum of Squared Errors
    f) Forecast 2011 rates
    g) 3 year moving average
    h) Create smoothing trend using weight of .7

    © BrainMass Inc. brainmass.com June 4, 2020, 1:14 am ad1c9bdddf


    Solution Summary

    The expert examines data analysis on a soft drink study.