Explore BrainMass
Share

Explore BrainMass

    Economics - Microeconomics

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

    When you gather data note prices and number of cars at each station. Use the number of cars for all stations to calculate market share. Then plot market share against price.

    I cannot figure out how to plot this in excel. Could you give me a quick tutorial in excel and show me how this is done. I have the data. See below.

    Total number of cars 25
    Gas Station 1 price 2.39--4 cars 16 % market share
    Gas Station 2 price 2.40--5 cars 20 % market share
    Gas Station 3 price 2.39--5 cars 20% market share
    Gas Station 4 price 2.40--2 cars .08% market share
    Gas Station 5 price 2.40--3 cars 12% market share
    Gas Station 6 price 2.38--6 cars 24% market share

    Please see attached file

    © BrainMass Inc. brainmass.com October 9, 2019, 10:10 pm ad1c9bdddf
    https://brainmass.com/economics/microeconomics/plot-market-shares-against-price-210619

    Attachments

    Solution Summary

    A Complete, Neat and Step-by-step solution is provided in the attached file.

    $2.19