Explore BrainMass
Share

Explore BrainMass

    Interpolating Data - Determining Average Values

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

    Under Federal Tab 1, find two ways to interpolate the data. Review District of Columbia observations and determine whether each is an outlier and if so, determine the replacement value. For each of the four variables in federal data, determine the average value for each value used with the missing value unchanged.

    Using the information under the Federal Debt Tab, find gross domestic product for all the years listed. Is sensitivity analysis needed? Why or why not?

    © BrainMass Inc. brainmass.com October 10, 2019, 6:19 am ad1c9bdddf
    https://brainmass.com/business/strategy-and-business-analysis/interpolating-data-determining-average-values-539460

    Attachments

    Solution Preview

    This tutorial must be read together with the attached Excel file.

    FEDERAL TAB
    1. Data interpolation
    a. Interpolation means constructing new data from given data. Simply, it means interpreting the data in a way that non-mythically educated people can understand
    b. Two methods
    i. Averaging data is one of the simplest way to interpolate a series of data
    • For example, the average total justice system is 502 which puts states such as Wyoming, District of Columbia and others to be above average.
    ii. Correlation coefficient measures the relationship between different ...

    Solution Summary

    The expert determines the aver values of interpolating data.

    $2.19