IS3310XTIB-DraftIRPProject.docx

IS3310XTIB-DraftIRPProject.docx - Tuesday 05:56:42 PM 1 To...

This preview shows page 1 - 2 out of 24 pages.

1 February 17, 2019 To: Dr. Shehane Subj: Independent Research Project Report: Avocados IRP Summary: Is there a statically significant correlation between avocado prices and the cities they are sold in? In other words, does the average avocado price vary by city? The subject matters because it is rather trendy for millennials to eat avocados. Therefore, finding a real trend based off data may help avocado-loving millennials decide where to live. Maybe future data will show a correlation between avocado prices and cities highly populated by millennials. Until that data comes out, this data will have to answer the question of: Do avocados prices and the cities they are sold in have a statistically significant correlation? This dataset contains 18,249 records with 13 attributes. It came from Kaggle, on online database website. The data includes avocados descriptions and their average prices. The data is broken down by city and average price. The data is ratio data since it is broken down by average prices. We first used SAS to run a Correlation Analysis. After comparing the data we ran a Linear Regression to find correlations. The results were interesting. The cheapest prices were for organic avocados in the Cincinnati Dayton region at $0.44 with a volume of 64,057. The highest volume accrued at 62,505,647 in the US at $0.87. It does seem the higher the volume, the higher the price and those were conventional avocados. Issue Identification: Do avocados prices and the cities they are sold in have a statistically significant correlation? This would be a yes. The highest priced avocados are located in San Francisco at $3.25 with a volume of 16,701. The volume is actually lower for this high-priced avocado. It seems the region or area has more to do with the price rather than the people that inhabitant those areas. Issue Analysis: I plan to find potential correlations by using a Linear Regression on SAS. I am going to use the average price as the dependent variable and the city or region as the continuous variable. I used a 95% confidence level and confidence limits for estimates. I manipulated the data to check which variables were irrelevant and which ones were not. I adjusted the assumptions by adding and removing values from the model section to achieve maximum efficiency. I investigated the data to answer the question: Do avocados prices and the cities they are sold in have a statistically significant correlation? Data: This dataset contains 18,249 records with 13 attributes. It came from Kaggle, on online database website. The data includes avocados descriptions and their average prices. The data is broken down by city and average price. The data is ratio data since it is broken down by average prices. Analysis: After running a regression, I examined the distribution of the observed data to predict G3. The distribution looks fairly normal, with the presence of some outliers at the base of the graph. Some are really close to zero, others are still very low values. The linear regression results show a F value of 68.99 and a p value <.0001 which is less than .05, therefore we can tell our model is
Image of page 1

Subscribe to view the full document.

Image of page 2
  • Fall '14
  • Avocado, Sandie, Southe Spokan, Dr. Shehane

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern