Describing Data Graphically And Numerically

Describing Data Graphically and Numerically

Project Description:

The present study shows data for sales of different sports equipment in 2017 in a sports supplies store. The sales are provided per month. We will identify the type of data for different variables and their measurement levels. We will analyze the data numerically using measures of central tendency (mean, median, minimum and maximum) and variability (range, interquartile range, standard deviation and variance). We will construct a frequency table and investigate the relationship between variables by analyzing the correlation. We will also represent the data graphically by using line charts and pie charts.

 

Step

Instructions

 

1

Use a cell reference or a single   formula where appropriate in order to receive full credit. Do not copy and   paste values or type values, as you will not receive full credit for your   answers.
Start Excel. Download and open the workbook named:
Describing   Data Graphically and Numerically Start

 

2

In merged cells D11-E11, select   the data type of “Equipment ID”.

 

3

In merged cells D12-E12, select   the data type of “sales for each month”.

 

4

In merged cells D13-E13, select   the data type of “Equipment”.

 

5

In cells O3 through O8, find the   total sales for each equipment.
Hint: Highlight the range C3:N8 and click the Quick Analysis Button that   appears on the lower right corner then click on the totals tab and use the   second Sum function.
 

6

In cells C9 through N9, find the   total sales for each month. In cell O9, find the total sales for the year.
Hint: Use the sum shortcut; click on cell C9 and then on your keyboard press   ALT then press =.
 

7

In cells P3 through P9, insert   Sparklines.
Hint: Click on cell P3, go to Insert Sparklines Line. Use the data   range C3:N3.
 

8

In cell D17, choose the correct   conclusion from the dropdown menu based on the line in cell P9.

 

9

In cell D18, find the average   sales per month in 2017.

 

10

In cell D19, find the median   sales per month in 2017.

 

11

In merged cells D20-E20, choose   the correct answer from the dropdown menu based on the answers in cells D18   and D19.

 

12

In cell D21, find the minimum   sales per month in 2017.

 

13

In cell D22, find the maximum   sales per month in 2017.

 

14

In cell D23, find the range of   sales per month in 2017.

 

15

In cells D24 and D25, find Q1   and Q3, respectively, for the sales per month in 2017.

 

16

In cell D26, find the   interquartile range per month in 2017.

 

17

In cells D27 through D31, find   the five-number summary for the sales per month in 2017.

 

18

In cell D32, find the standard   deviation in sales per month in 2017.

 

19

In cell D33, find the variance   in sales per month in 2017.

 

20

In cell F35 through F40,   construct a frequency table for the total sales in 2017 for each piece of   equipment.

 

21

In merged cells E41-F41, find   the correlation between “Balls” sales and “Goals” sales.

 

22

In merged cells E42-F42, find   the correlation between “Nets” sales and “Rods and   tackles” sales.

 

23

In merged cells D43-F43, choose   the correct answer from the dropdown menu based on the correlation values.

 

24

Case study. Case 8.3: “Timberland’s Culture Rooted in Community Building”. p. 244

Case study. Case 8.3: “Timberland’s Culture Rooted in Community Building”. p. 244

Case study. Case study. Case 8.3: “Timberland’s Culture Rooted in Community Building”.  p. 244

Students must complete the Case Study essay as assigned.  The assignment should be done in the form of an essay to include a cover page and a reference page, both in APA format. The body of the essay should be 450- 500 words in length and conform to APA format to include proper in text citation.  Students must use at least two peer-reviewed references in addition to the assigned reading materials.

 

Must be completed by 8 p.m. tomorrow.

__________ addresses the question of how to handle our day-to-day business needs.

BU 340 EXAM 1, 3, 5 AND 7

EXAM 1
__________ addresses the question of how to handle our day-to-day business needs.

A. Capital budgeting

B. Capital structure

C. Working capital management

D. Accounts receivable management

A __________ is a business that is jointly owned by two or more individuals.

A. partnership

B. sole proprietorship

C. subchapter S corporation

D. corporation

Capital budgeting is best defined by which of the following questions?

A. How will we fund our product and service choices?

B. What business are we in?

C. How will we manage our day-to-day financial needs?

D. What is our firm’s best choice for corporate governance?

Of the following, which is NOT one of the four main areas of finance?

A. International Finance

B. Corporate Finance

C. Investments

D. All are considered main areas of finance.

The movement of money from lender to borrower and back again is known as:

A. the circle of life.

B. corporate finance.

C. the cycle of money.

D. money laundering.

The form of business organization in the United States that has the greatest amount of capital is:

A. the sole proprietorship.

B. the partnership.

C. the subchapter corporation.

D. the publicly traded corporation.

Financial assets that will mature within a year are bought and sold in the __________ market.

A. debt

B. capital

C. stock

D. money

Currencies are bought and sold in __________ markets.

A. equity

B. debt

C. derivatives

D. foreign exchange

Capital structure is best defined by which of the following questions?

A. How will we fund our product and service choices?

B. What business are we in?

C. How will we manage our day-to-day financial needs?

D. What is our firm’s best choice for corporate governance?

In agency theory, the owners of the business are referred to as __________, and the managers are referred to as __________.

A. bondholders, principals

B. stockholders, bondholders

C. agents, principals

D. principals, agents

__________ is the area of finance concerned with the activities of buying and selling financial assets such as stocks and bonds.

A. Investments

B. Corporate finance

C. International finance

D. Financial markets and institutions

The sale of “new” securities, where the financial asset is being traded for the very first time, is said to take place in the __________ market.

A. primary

B. money

C. secondary

D. capital

“Concern with the multinational elements of financial activities” best describes which of the four main areas of finance?

A. Investments

B. International finance

C. Corporate finance

D. Financial institutions and markets

Which of the following best identifies the four main areas of finance?

A. Exchange rate management, investments, financial institutions and markets, international

B. Corporate, investments, capital structure, international

C. Corporate, investments, financial institutions and markets, international

D. Corporate, capital budgeting, financial institutions and markets, regulation

Which of the following is an advantage of a sole proprietorship?

A. The owner’s unlimited liability

B. The lack of continuity upon death of the owner

C. The ease of start-up

D. The ability to raise capital

Stocks are bought and sold in __________ markets.

A. equity

B. debt

C. derivatives

D. foreign exchange

The problem of motivating one party to act in the best interest of another party is known as the:

A. leadership directive.

B. management priority.

C. principal-agent problem.

D. sigma six structure.

The set of financial activities that support the OPERATIONS of a business is best described by which main area of finance?

A. Corporate finance

B. Investments

C. Financial institutions and markets

D. International finance

__________ are the forums where buyers and sellers of financial assets and commodities meet.

Phenomenological Inquiry: Data Sources, Data Analysis, Alignment, and Rationale

In your upcoming residency, you will need to justify your choices relative to the research design of your proposed study. Throughout this course, you will explore data sources and analysis options for several qualitative research designs. You will also explore how to justify the choices of data sources and data analysis and align those components with the remainder of the proposed research study. In this assignment, you will explore the data sources and analysis options for conducting your proposed dissertation research study using a phenomenological inquiry design. You will also explain how well these might align with the components of your proposed research study as you described them in the previous course. Given the data sources, data analysis options, and alignment considerations, you will also offer a rationale for potentially choosing the phenomenological inquiry design.

General Requirements:Use the following information to ensure successful completion of the assignment:

  • Refer to the problem statement, purpose statement, and research questions you drafted for conducting your potential research study as a qualitative case study during the previous course.
  • This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion.
  • Doctoral learners are required to use APA style for their writing assignments. The APA Style Guide is located in the Student Success Center.
  • Refer to the Publication Manual of the American Psychological Association for specific guidelines related to doctoral level writing. The manual contains essential information on manuscript structure and content, clear and concise writing, and academic grammar and usage.
  • This assignment requires that at least two additional scholarly research sources related to this topic, and at least one in-text citation from each source be included.
  • You are required to submit this assignment to LopesWrite. A link to the LopesWrite technical support articles is located in Class Resources if you need assistance.

Directions:Consider the specific language designated by GCU as indicative of qualitative research.Write a paper (1,500-1,750 words) in which you discuss the data sources and data analysis options for conducting your proposed dissertation research study using a phenomenological inquiry design. Include the following in your discussion:

  1. State the problem statement, purpose statement, and research questions you drafted for conducting your potential research study as a phenomenological inquiry during the previous course.
  2. A description of potential data sources for the study. Use language appropriate to a phenomenological  design.
  3. A description of potential data analysis approaches for the study. Use language appropriate to a phenomenological design.
  4. A discussion of how well these potential data sources and analysis approaches align with the previously developed phenomenological inquiry components of the potential research study.
  5. An analysis of the fit and alignment of this design to the proposed problem statement, purpose statement, research questions, data sources, and data analysis approaches. Do you believe this is a reasonable design for addressing your study topic? Why or why not?

In additional 500-750 words, present a reasoned decision for choosing a qualitative descriptive, qualitative case study, or phenomenological inquiry design for your proposed research study. Why will your chosen method be the best fit for your proposed research study while others will not? What should you do if none of these designs is fully adequate for our proposed study? Explain.