A data audit is a critical activity that must be done at the beginning of any analytics project when you are working with an existing workbook or are given a dataset from another person. The purpose of this exercise is to conduct a data audit on a worksheet that contains sales data for a hypothetical apparel retailer.
The data shown in the file named Chapter 1 DA Exercise 2 contains data that was provided to you by a coworker. The Excel file should contain sales data for two years by month. You intend to use this data to evaluate the company’s sales trend by season. In addition, you will need to analyze the average price per month to determine if there are months where customers are spending more money for each item purchased. The data should contain sales in units and dollars. For any given month, the sales in units multiplied by the average price should equal the sales in dollars. Open the file named Chapter 1 DA Exercise 2. Audit the data in the Sheet1 worksheet. Record any problems you find in the dataset in the AnswerSheet worksheet. Note that there are more rows to document problems in the dataset than are needed.
| Company Sales Data | ||||
| Year | Month | Unit Sales | Average Price | Sales Dollars |
| 2017 | January | 6,000 | 9.99 | $ 59,940 |
| 2017 | February | 4,500 | 12.49 | $ 56,205 |
| 2017 | March | 4,500 | 14.99 | $ 67,455 |
| 2017 | April | 3,000 | 16.99 | $ 50,970 |
| 2017 | May | 3,000 | 17.99 | $ 53,970 |
| 2017 | June | 1,500 | 14.99 | $ 22,485 |
| 2017 | June | 1,500 | 14.99 | $ 22,485 |
| 2017 | August | 3,000 | 17.49 | $ 52,470 |
| 2017 | September | 4,000 | 19.99 | $ 79,960 |
| 2017 | October | 5,000 | 19.99 | $ 99,950 |
| 2017 | November | 6,000 | 17.49 | $ 104,940 |
| 2017 | December | 7,500 | 14.99 | $ 112,425 |
| 2018 | January | 6,250 | 8.49 | $ 53,063 |
| 2018 | February | 5,000 | 12.99 | $ 64,950 |
| 2018 | March | 6,000 | 12.99 | $ 950 |
| 2018 | April | 3,500 | 17.49 | $ 61,215 |
| 2018 | May | 2,500 | 16.49 | $ 41,225 |
| 2018 | June | 2,000 | 14.99 | $ 29,980 |
| 2018 | July | 3,000 | 10.99 | $ 32,970 |
| 2018 | August | 3,000 | 10.99 | $ 32,970 |
| 2018 | September | 4,500 | 19.49 | $ 87,705 |
| 2018 | October | 5,200 | 21.49 | $ 111,748 |
| 2018 | December | 8,000 | 13.99 | $ 111,920 |
| Use this worksheet to answer any written questions for this exercise. | ||||||||
| Write your answer in the merged open cell next to each Question number. | ||||||||
| Question | Response | |||||||
| 1 | ||||||||
| 2 | ||||||||
| 3 | ||||||||
| 4 | ||||||||
| 5 | ||||||||
| 6 | ||||||||
| 7 | ||||||||
| 8 | ||||||||
| 9 | ||||||||
In: Accounting
Human bones and the bones of other vertebrates share the same anatomical plan. They are homologous structures rather than analogous structures such as a dragonfly wing and bird wing. Comparing and contrasting the anatomy of similar organisms assists with understanding of how the body is put together.
Check out the limbs figure on this webpage: Homologous Structures. Pick one of the animal limbs for the discussion below (horse, cat, bat, bird, or whale limb).
1. In your own words, explain two ways in which the animal limb bones are similar to human limb bones.
2. In your own words, explain two ways in which the animal limb bones are different from human limb bones.
In: Biology
Sickle cell anaemia: The selective forces that a population experiences can vary by context, especially by geographic place.
a. Explain how natural selection affects the evolution of haemoglobin in humans and how and why the selective pressures differ among human populations. Use Africa and Europe as examples of human populations, give genotypes and explain selective pressures.
b. Is natural selection on haemoglobin in African populations best described as disruptive, stabilizing or directional selection?
c. Is natural selection on haemoglobin in Australian populations (no malaria) best described as disruptive, stabilizing or directional selection?
d. For human populations living in Australia (no malaria), do you expect the Hs allele to eventually go extinct? Explain why or why not.
In: Biology
"Looking Back and Ahead"
Class: Health Information Systems
Review the course outcomes. Looking back on everything you have learned in this class,
what has been the most surprising or interesting lesson learned? Why?
Predict what the focus of health information systems will be ten (10) years from now. Justify your post with examples.
Additionally, consider an example of a human technology interface in healthcare, from clinical technology to administrative or electronic data.
Propose one way the future of healthcare will improve with Human Interface Technology.
Next, provide one (1) example of how Human Interface Technology could hinder future healthcare delivery. Justify your response.
In: Nursing
Sickle cell anaemia: The selective forces that a population experiences can vary by context, especially by geographic place.
a. Explain how natural selection affects the evolution of haemoglobin in humans and how and why the selective pressures differ among human populations. Use Africa and Europe as examples of human populations, give genotypes and explain selective pressures.
b. Is natural selection on haemoglobin in African populations best described as disruptive, stabilizing or directional selection?
c. Is natural selection on haemoglobin in Australian populations (no malaria) best described as disruptive, stabilizing or directional selection?
d. For human populations living in Australia (no malaria), do you expect the Hs allele to eventually go extinct? Explain why or why not.
In: Biology
1. What is the opportunity cost of investing in capital?
a) The loss of consumption that results from redirecting resources toward investment
b) Higher taxes
c) Improved technology that leads to faster growth
2. True or False: If the extra output produced from an additional unit of capital falls as the stock of capital rises, the country is possibly overinvesting in capital.
3. What is the opportunity cost of investing in human capital?
a) Lower taxes
b) Improved technology that leads to faster growth
c) The goods or resources that could be produced if not investing in human capital
4. True or False: A country is possibly overinvesting in human capital if the best job a Ph.D. in philosophy can find is managing a restaurant.
In: Economics
Flex-time and telework have become the new norm due to the global pandemic. The issue of ‘netiquette’ or behaving appropriately during online business meetings is increasingly becoming a concern for managers and organisations. Examine three of these inappropriate behaviours and make recommendations .
In: Operations Management
In: Math
2. List six competitive challenges faced by Canadian
organizations. Describe and give an example of any one of the six
challenges faced by an organization you are familiar with.
Human resource management subject
3. Define strategic HRM and how it is linked to an organization’s
business strategy. Provide an example.
4. Define and give three examples of one human right legal concept
affecting managers and HRMs
5.As the HRM, what six questions would you ask in order to gather job information that would help you write a job description?
6. What three factors should be considered in
designing a job?
10. Three reasons why you are studying a human resource management
program?
In: Economics
One of the questions on a survey asked adults if they used the internet at least occasionally. The results showed that 457 out of 478 adults aged 18–29 answered Yes; 743 out of 833 adults aged 30–49 answered Yes; 1,061 out of 1,644 adults aged 50 and over answered Yes. (Round your answers to four decimal places.)
(a)
Develop a point estimate of the proportion of adults aged 18–29 who use the internet.
(b)
Develop a point estimate of the proportion of adults aged 30–49 who use the internet.
(c)
Develop a point estimate of the proportion of adults aged 50 and over who use the internet.
(d)
Comment on any relationship between age and Internet use that seems apparent. (multiple Choice)
-Adults aged 30–49 are less likely to use the internet than adults aged 50 and over.
-Older adults are more likely to use the internet.
-Younger adults are more likely to use the internet.
-Adults aged 30–49 are the least likely to use the internet.
(e)
Suppose your target population of interest is that of all adults (18 years of age and over). Develop an estimate of the proportion of that population who use the internet.
In: Statistics and Probability