MBA5008 - Copy

docx

School

Gannon University *

*We aren’t endorsed by this school

Course

5008

Subject

Business

Date

Jun 10, 2024

Type

docx

Pages

Uploaded by dicarlo002

Using Analytic Techniques to Add Meaning to Data Maria DiCarlo Capella University Applied Business Analytics December 26, 2023 Starbucks Corporation, the global coffeehouse giant, has become synonymous with premium coffee experiences, shaping the contemporary coffee culture worldwide. This

introduction explores the rich background of Starbucks, diving into its historical roots, mission, platforms, product offerings, and competitive landscape, drawing insights from a diverse range of sources to provide a comprehensive overview. Founded in Seattle, Washington, in 1971 by Jerry Baldwin, Zev Siegl, and Gordon Bowker, Starbucks initially operated as a single store that primarily sold high-quality coffee beans and equipment. Inspired by the rich coffee culture of Italy, the founders aimed to create a space where customers could experience the art of coffee roasting (Petruzzello, 2023). The brand rapidly expanded throughout the 1980s and 1990s, transforming into a global phenomenon. Today, Starbucks is not merely a coffeehouse chain; it is a cultural phenomenon that has redefined the way people perceive and consume coffee. At the core of Starbucks' success is its unwavering commitment to its mission "to inspire and nurture the human spirit—one person, one cup, and one neighborhood at a time." This mission underscores the company's emphasis on community, sustainability, and creating meaningful connections. Starbucks prioritizes ethical sourcing, supporting farmers, and minimizing its environmental footprint, aligning its business practices with social responsibility. Starbucks operates through various platforms, including its iconic coffeehouses, drive-thru locations, and a robust mobile app (Peiper, 2023). The company's product range extends beyond traditional coffee, encompassing a diverse array of beverages, pastries, and merchandise. Starbucks has successfully adapted to evolving consumer preferences, introducing innovations like the Pumpkin Spice Latte and continuously expanding its menu to cater to diverse tastes and preferences. Starbucks' competitive advantage lies in its ability to blend innovation with a commitment to quality. The company has successfully created a unique atmosphere in its

stores, combining ambient settings with the irresistible aroma of freshly brewed coffee. This distinctive customer experience, coupled with a global presence and an extensive loyalty program, positions Starbucks as a leader in the highly competitive coffee industry. Starbucks faces competition from a range of players, including global chains such as Dunkin' and local artisanal coffee shops. The industry dynamics are influenced by factors like consumer trends, economic conditions, and evolving preferences. Starbucks has navigated these challenges by embracing digitalization, investing in technology, and staying attuned to shifting consumer demands. Graphical Representations of Data 12/5/2 2 1/24/23 3/15/23 5/4 /23 6/2 3/2 3 8/12/23 10/1/2 3 11/20/23 1/9/24 2/28/24 0 20 40 60 80 100 120 Scatterplot of Highest Stock Prices Time in Days Stock Prices in U.S Dollars To generate a scatterplot depicting the highest stock prices, start by confirming that the information from the Date column (column 1) and the High column (column 3) is arranged in consecutive columns and highlighted. Then, navigate to the Insert tab, click on Charts in the

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

drop-down menu, and choose the More Scatter Charts option to pick the suitable scatter chart for your data. From there, add graph title, and title both axis lines. 12/5/2 2 1/24/23 3/15/23 5/4 /23 6/2 3/2 3 8/12/23 10/1/2 3 11/20/23 1/9/24 2/28/24 0 20 40 60 80 100 120 Scatterplot of Lowest Stock Prices Time in Days Stock Prices in U.S Dollars To create a scatterplot illustrating the lowest stock prices over time in Excel 2016, follow the identical steps employed for the highest stock prices. The sole distinction lies in the selection of data; when choosing data in Excel 2016, specifically highlight the information from the Date column (column 1) and the Low column (column 4). 90 95 100 105 110 115 More 0 20 40 60 80 100 120 Histogram of Adjacent Closing Stock Price Frequency Ranges of Adjacent Closing Stock Price Number of Occurences

To construct a histogram representing the closing stock prices of Starbucks, access the Data tab. Click on Data Analysis, then choose Histogram and click OK to access the histogram settings page. Specify the Input Range as the dataset for adjacent closing stock prices (column 6). For the Bin Range, establish a dataset in a separate column. Determine the bin size based on the lowest and highest closing stock prices. For instance, Starbuck’s closing stock prices range from 85 to 115, making a bin size of 5 appropriate, resulting in a histogram with 6 bins. Create a dataset in column H with values 90, 95, 100, 105, 110, and 115, representing the bin range. For the Output Range, select any empty cell. Check the Chart Output option and click OK to generate the histogram. 3000000 5000000 7000000 9000000 11000000 13000000 1500000 0 More 0 40 80 120 Histogram of Stock Trade Volume Frequency Ranges of Stock Trade Volume Number of Occureences Descriptive Statistics Adjusted Daily Closing Stock Price Mean 99.7791018 Median 99.618454 Mode 97.161484 Standard Deviation 6.953752

Stock Volume Mean 6535967.21 Median 5973400 Standard Deviation 2942419.94 To compute the average of the adjusted closing stock price in Excel 2016, begin by navigating to the home page and clicking on the Formulas tab. From there, access the More Functions option in the drop-down menu. Subsequently, choose the Statistical category and opt for Average in the list. In the Functions Argument page for the average, designate the Number 1 option by highlighting the dataset for the adjacent closing stock price located in column 6. Then, click OK to generate the mean. It is crucial to ensure that an empty cell is chosen before selecting the More Functions option. To determine the median of the adjusted closing stock price using Excel 2016, navigate to the Formulas tab. Choose the More Functions option, then access the Statistical bar and opt for Median from the list. In the Functions Argument page for the median, specify the data set for the adjacent closing stock price, and click OK to generate the median. Ensure that an empty cell is chosen before initiating the process to prevent overwriting existing data points. The calculated median for Microsoft Corporation's adjacent closing stock price during the period from February 2018 to February 2019 is $103.24 USD. In Excel, the formula for calculating the mode is =MODE(C2:C8) when the data is located in column C within cells 2 to 8. To compute the mode using Excel 2016, first, highlight the data intended for the calculation. Next, go to the Formulas tab, click on the More Functions option, choose the Statistical bar, and opt for MODE.SNGL. Subsequently, input the cell numbers as specified earlier. To compute the standard deviation of the adjusted closing stock price using Excel 2016, begin by navigating to the Formulas tab. From there, access the More Functions option, choose the Statistical bar, and opt for the Standard Deviation Sample (STDEV.S) option. In the Functions Argument page, designate the data set for the adjacent closing stock price as the Number 1 option, and click OK to generate the standard deviation. Similar to the mean and median calculations, it is essential to select an empty cell before initiating the standard deviation calculation. The calculated standard deviation for Microsoft Corporation's adjacent closing stock price during the period from February 2018 to February 2019 is determined to be 6.953. Summary References

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Petruzzello, M. (2023, December 28). Starbucks . Encyclopædia Britannica. https://www.britannica.com/topic/Starbucks Peiper, H. (2023, April 24). A new mission for Starbucks . Starbucks Stories . https://stories.starbucks.com/stories/2023/a-new-mission-for-starbucks/

MBA5008 - Copy

Related Documents