Describing Data Graphically And Numerically

/in /by

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.

 

Expectancy Theory Of Motivation

/in /by

Using the Expectancy theory of motivation as the framework for analysis, address the following questions for each case.

  1. What is the employee’s level of motivation? High, medium, low or negative.
  2. What is the employees EI, EII and net preference?
  3. What are all the reasons for the employee having an EI, EII and/or net preference problems?
  4. How would you address the motivational issue for each employee?

You have posted for this week in your module an “Outline of  Expectancy theory.” You should use this outline in your analysis and  discussion.

Case No. 1

The Aide who neglected patient care

Brenda, an aide on the third floor,  has been with the hospital for six years. Her duties are divided into  two areas: Regularly assigned duties which are performed during the  shift and attending to the patients as called upon. The supervisor has  noticed that Brenda spends the first part socializing with other  employees. The last half of the shift, she displays a monumental effort  to complete her assigned duties which she has managed to complete a few  minutes before the end of her shift. The R.N. on duty complains that  Brenda neglects her patient care during the latter part of the shift, as  she has little time for anything besides her assigned duties. Brenda a  supervisor approached her concerning the neglect of patient care. Brenda  responded, ‘I do my job.”

Case No. 2

The R.N. who missed the code

Cindy is a recent graduate of a four  year nursing program at a prestigious private school in New England. She  finished in the top of her class and performed exceptionally well on  the national nursing exam. In her three months at the county hospital,  she has always arrived early to work and stayed an extra ten minutes to  insure that everything is correct for the next shift. Linda, the other  R.N. on the shift, has complained to the supervisor that since Cindy has  been working on the shift, three Maydays have occurred. While Cindy was  in no way responsible for these events, on all three occasions an R.N.  from another nursing station was called in because Cindy could not be  found to help out. The supervisor approached Cindy about the problem.  Cindy responded, “I must have been busy somewhere else and missed the  Mayday call on two occasions. On the third occasion, I heard the call  but assumed that Linda could handle the situation. I’m not really sure  if I could be much help. After all, Linda and the orderlies were working  on the situation.”

Financial Analysis: Financial Figures and Concepts: POWERPOINT PRESENTATION

/in /by

Financial Analysis: Financial Figures and Concepts: POWERPOINT PRESENTATION

DUE 02/28/2018

In anticipation of Mary’s request for comparative analysis, it will be useful at this time to do some research. You know that you can obtain the financials of companies within the same sector or Standard Industry Code as Apix Printing (e.g., commercial printing), and that the North American Industry Classification System (NAICS) Standard Industry 2012 code for Apix Printing is presently 323111. Use the  FINC615 Library Guide – SEC BELOW) to search for two other companies in the same industry as Apix Printing.

When you get to work the next day, you see the following e-mail from Mary:

Here is the list of financial ratios you asked for. I need you to explain the computation of each and compute these for Apix’s results for the financial statements you are using for the PowerPoint presentation.

Also, compare Apix’s 2-year trend results to that of two other firms in the sector. Indicate how each of Apix’s ratios differ,and indicate whether the two other companies’ ratios or Apix’s ratios are indicative of better performance.

Explain the computation for each of the following, and compute each for Apix and two other companies in the same industry as Apix Printing:

· Current ratio

· (Long-term) debt to equity ratio

· Gross margin percentage

· Net profit margin percentage

· Return on equity percentage

Present your findings of the above data in a table. Add a paragraph that summarizes your results, indicating whether investors would find the financial analysis results of Apix competitive as compared to rivals in the sector. Be sure to include both positive and negative trends in your analysis.

USE BELOW GUIDE FROM SEC REPORTS AND OTHER SOURCES

Search for US companies with the highest revenue and Use one of them Make note of the ticker symbol that appears in parentheses to the right of a company’s name. You can use a company’s ticker symbol on the stock market to more easily look up financial information about the company on the U.S. Securities and Exchange Commission’s website (For example, the ticker symbol for R.R. Donnelley & Sons Company is: RRD)

SEC EDGAR Website Public companies in the United States are required by law to report financial information to the U.S. Securities and Exchange Commission (SEC). These reports are made available to the public on the SEC’s website, in their Electronic Data Gathering, Analysis, and Retrieval system (EDGAR).

: https://www.sec.gov/answers/reada10k.htm and then: http://www.marketwatch.com/tools/quotes/lookup.asp

SEC EDGAR website: https://www.sec.gov/edgar/searchedgar/companysearch.html

· The report will open, and you can scroll through it to look for the financial information you need to find.

MORE SOURCES TO USE BELOW

References

Bridges Investment Management. (2005, January 31). January newsletter. Retrieved from http://www.bridgesinv.com/media/Bridges_January_31_05.pdf

NetMBA. (n.d.). Financial ratios. Retrieved from http://www.netmba.com/finance/financial/ratios/

Profit. (n.d.). Retrieved from the Merriam-Webster Online Dictionary Web site: http://www.merriam-webster.com/dictionary/profit

The Hofstede Centre. (n.d.). Retrieved from http://www.geert-hofstede.com/

United States Department of Agriculture. (2013, October 30). International macroeconomic data set. Retrieved from http://www.ers.usda.gov/Data/Macroeconomics/#HistoricalMacroTables

Brigham, E., & Ehrhardt, M. (2008). Financial management (12th ed.). Mason, OH: Thomson.

Spiceland, J., Sepe, J., & Tomassina, L. (2007). Intermediate accounting (4th ed.). New York: McGraw-Hill/Irwin

What factors might lead you to not insist on confidentiality?

/in /by

1.   Read the following recent NH Supreme Court Case that reflects on the 4th and 14th Amendments to the Constitution.

Assignment:  Explain the court’s reasoning for finding that the defendant (Shawn Johnson) had no reasonable expectation of privacy with respect to an aerial the search of his property.  This assignment should be able to be completed in a few paragraphs.  This assignment is to get you used to reading case law and learning how to analyze the issues the issues the court is trying to address.

http://www.courts.state.nh.us/supreme/opinions/2009/johns091.pdf
2.  READ “A Manager’s Dilemma” on pgs. 107-108 of the Bagley text regarding Confidential Settlements.

http://s1.downloadmienphi.net/file/downloadfile7/149/1379786.pdf
1.  If you were a manager responsible for major litigation, what factors would you take into account in deciding whether to insist on a confidentiality clause in a settlement agreement?

2.  What factors might lead you to not insist on confidentiality?

3.  Read the NH Supreme Court case Impact Food Sales, Inc. v. Carl Evans D/B/A Warehouse Club Distributing Company (2010)

http://www.courts.state.nh.us/supreme/opinions/2010/2010061impac.pdf

This is an interesting case because it started as a breach of contract claim, with Impact Foods claiming that it did not receive goods from Evans (Warehouse Club Distributing Company) for which it had paid.

The Superior Court denied the defendants’ motions to vacate judgment and dismiss the case.  The defendant appealed based on insufficient service of process.  (Think of this from a constitutional point of view).

In a few paragraphs, explain why service of process is so important in any case (criminal or civil), and whether or not you agree that the Supreme Court was correct in reversing the lower court’s decision.

4.  Shortly after hiring Adams, Goodyear Tires transferred him from Houston, which was near his home, to Bryan, Texas, to work on commercial trucks. After the transfer, Adams continued to live in Houston and commuted two hours each way to work. Although Adams owned his own  truck to commute to and from work. Once or twice a week, Adams either picked up tires at the Houston shop on his way to work and delivered them to Bryan, or dropped tires from Bryan at the Houston shop on the way home. With his boss’s knowledge, Adams also used the Goodyear truck during working hours to run some personal errands. After Adams left work in the company car on a Friday, he delivered tires to the Houston shop at 7 p.m., stopped for Chinese takeout, and drove to his father’s house, which was about ten miles from his home, where he ate dinner, drank a few beers, and fell asleep. At 1 a.m. he woke up and drove the car to a store to buy cigarettes for his father. On the way back to his father’s house, Adams fell asleep at the wheel and hit another car, severely injuring himself and the other driver. After the driver sued Adams and Goodyear, Travelers Indemnity Company (Goodyear’s insurance company) refused to cover Adams or to defend or indemnify him in the lawsuit, and Adams sued Travelers and Goodyear. Travelers argued that Adams was not an “insured” under its policy with Goodyear because he did not have permission to use the truck when the accident occurred.

Did Adams have implied permission to use the truck? Is Goodyear (and therefore Travelers) liable for damages arising out of the accident? If so, on what basis?

5.  Read the following recent NH Supreme Court case (Goudreault v. Kleeman) in its entirety and then discuss the following:

http://www.courts.state.nh.us/supreme/opinions/2009/goudr005.pdf
The Court discusses in its opinion the theory of joint and several liability.  In your own opinion, who should be found at fault in this case, if anyone?