Accounting homework help

Excel Project: Part I Instructions
Company Information (Tab 1), and 
Historical Income Statements, Balance Sheets, and Cash Flows (Tabs 2-4)
Can you please complete it for Walt Disney (DIS)
· Choose one of the 3 companies listed in your Instructor’s Week 1 Announcement.
· Go to the Securities and Exchange Commission’s EDGAR database and access your chosen company’s most recent Form 10-K (annual report). (For help with this process, see the Module/Week 1 presentation, “Downloading Financial Statements from the SEC EDGAR Database.”)
· Create an Excel workbook, including data for your chosen company as follows:
o The 1st tab (worksheet) in your Financial Statement Analysis Template must be labeled Company Information. The following information must be included:
§ Company Name and ticker symbol
§ Industry
§ Products or services offered
§ Major competitors
§ An example of this tab is provided in Exhibit A.
o The 2nd tab in your Financial Statement Analysis Template must be labeled Historical Income Statements.
§ Include the latest three years based on SEC filings.
§ Ensure that the worksheet includes a header with:
· Company Name
· Financial Statement Name (Income Statements)
· Financial Statement Dates
· Denomination level ($s in millions or thousands, etc.)
o The 3rd tab in your Financial Statement Analysis Template must be labeled Historical Balance Sheets.
§ Include the latest three years based on SEC (10-K) filings. (Note: Some 10-Ks only provided 2 years of balance sheet data. You may need to download the second most recent 10-K for your company in order to obtain 3 years of balance sheet data.)
§ Ensure that the worksheet includes a header with:
· Company Name
· Financial Statement Name
· Financial Statement Dates
· Denomination level ($s in millions or thousands, etc.)
§ A partial balance sheet example is provided in Exhibit B.
o The 4th tab in your Financial Statement Analysis Template must be labeled Historical Statement of Cash Flows.
§ Include the latest three years based on SEC (10-K) filings.
§ Make sure that the Income Statement, Balance Sheet, and Cash Flows Statement tie in as follows:
· Net Income from Income Statement agrees with Net Income on the Statement of Cash Flows.
· Ending Cash Balance from Statement of Cash Flows agrees with Cash in the Balance Sheet.
§ Ensure that the worksheet includes a header with:
· Company Name
· Financial Statement Name
· Financial Statement Dates
· Denomination level ($s in millions or thousands, etc.)
o Other instructions:
§ The Excel workbook should be professionally formatted. Professional formatting includes:
· All numbers are formatted similarly. The use of decimals, commas for thousands, and other formatting is consistent.
· Dollar signs are included in the first and last numbers of each column.
· Subtotals and totals are preceded by a single underline. Totals are followed by a double underline.
· All extraneous information is removed from the spreadsheet. Sometimes, files downloaded from the SEC website contains extra characters or other things that need to be deleted.
· Line descriptions are indented/bolded in a manner that makes the spreadsheet easy to read.
§ All totals and subtotals should be calculated using formulas.  For an example of which cells may need formulas, please see Exhibit B.
This assignment is due by 11:59 p.m. (ET) on Monday of Module/Week 2.
Exhibit A: Example Company Information Tab
 
Exhibit B: Example Historical Balance Sheets Tab
(IMPORTANT NOTE: Only Partial Balance Sheet shown. Your Balance Sheet should include Liabilities and Stockholders’ Equity as well.)
 
  • attachment

    ACCT370-INSTRUCTIONS-EXECL1.docx

English homework help

Proposal on : This is a 5-8 page research paper or concerning a topic related to texts read during the course. You should pick a topic that interests you and in tandem with either one or two texts read during the course. You must use no less than five peer-reviewed sources (cited in MLA) for your final paper.
THIS ASSIGNMENT IS ONLY THE ANNOTATED BIBLIOGRAPHY AND A PROPOSAL FOR THE PROJECT NOT THE ASSIGNMENT LISTED.
The topic I choose will be based on Joseph Conrad’s book “Heart of Darkness” and Chinua Achebe’s book Things Fall Apart and his paper “An Image of Africa”. Basically like how each author is portraying Africa in their writings etc, the drastic differences and like the impact each has on how an audience may view Africa/Africnas etc

Sociology homework help

Discussion 1: Group Research Design
There are several different types of research designs. Each design is intended to respond to a particular type of research question. The type of research design depends on the type of research questions asked. For this Discussion, select one of the articles from the reading list and consider several classifications of group research designs.
By Day 3
Post your response to the following: Describe which groups are compared in the research. Then, classify the research design as follows:
By explaining whether the study is pre-experimental (cross-sectional, one-shot case study, and longitudinal), experimental (control group with pretest and posttest, posttest only, or four-group design), or quasi-experimental (comparing one group to itself at different times or comparing two different groups)
By indicating what the researchers report about limitations of the study
By explaining concerns you have regarding internal validity and the ability of the study to draw conclusions about causality
By explaining any concerns you have about the generalizability of the study (external validity) and what aspect of the research design might limit generalizability
Please use the resources to support your answer.
\
Discussion 2: Pretests/Posttests and Attrition
This week’s video introduces you to the Hernandez family. Juan and Elena Hernandez are mandated to attend parenting classes. As part of the parenting classes, they are required to participate in both a pretest (taken before classes begin) and a posttest (taken after classes end). Pretests and posttests can yield very useful information. They can measure the learning that has or has not taken place as a result of the education being provided. For this Discussion, imagine what kinds of questions would be on a pretest and posttest for this particular study sample (the parents who are taking parenting classes).
By Day 5
Post your explanation of what you think the social workers wanted to know when they designed the pre/posttest for evaluating the parenting classes. Be sure to address the concept of attrition and whether or not you believe they took that into account. Be sure to explain why. Then, analyze potential lessons learned from attrition. Finally, explain how you might design a study to gather data about the effectiveness of these parenting classes. Use the following questions to focus your thinking:
Would you recommend a pre-experimental, experimental, or quasi-experimental design?
Would the study involve measurement over time?
Would there be a control group?
In this group research design you imagine, what or who will be compared?
What limitations in terms of generalizability and internal validity can you anticipate based on the research plan you envision?
What can you tell the social worker about the issue of client drop out (also called attrition or experimental mortality)?
If there is no control group, what type of research design could answer the question: Is this parent training class effective in reducing abusive parenting practices?
Please use the resources to support your answer.

Chemistry homework help

Determine the pH in a 0.667 M NaOH solution.
Group of answer choices0.12
0.18
14.18
13.88
13.82
Question 22 pts
What is the pH of a buffer solution that is 0.192 M in lactic acid and 0.155 M in sodium lactate? The Ka of lactic acid is 1.4 × 10-4.
Group of answer choices3.94
14.09
10.24
3.76
5.48
Question 32 pts
Determine the pH of a 0.22 M NaF solution at 25°C. The Ka of HF is 3.5 × 10-5.
Group of answer choices5.10
11.44
10.20
8.90
2.56
Question 42 pts
Which of the following compounds solubility will NOT be affected by a low pH in solution?
Group of answer choicesBaCO3
AgCl
CuS
Mg(OH)2
BaF2
Question 52 pts
Determine the molar solubility of CaSO4 in a solution containing 0.060 M Na2SO4. Ksp (CaSO4) = 2.4 × 10-5.
Group of answer choices5.8 × 10-10 M
4.0 × 10-4 M
0.30 M
1.4 × 10-6 M
4.9 × 10-3 M
Question 62 pts
Calculate the pH for an aqueous solution of pyridine that contains  hydroxide ion.
Group of answer choices4.15 × 10-4
7.05
2.41 × 10-11
10.62
3.38
Question 72 pts
Identify the base that is in baking soda.
Group of answer choicesNaHCO3
LiOH
KHCO3
RbOH
Li2CO3
Question 82 pts
A 25.0 mL sample of 0.150 M butanoic acid is titrated with a 0.150 M NaOH solution. What is the pH at the equivalence point? The Ka of butanoic acid is 1.5 × 10-5.
Group of answer choices8.85
11.82
9.18
7.10
4.82
Question 92 pts
Determine the [H3O+] concentration for a 0.200 M solution of HCl.
Group of answer choices1.00 × 10-1 M
4.00 × 10-1 M
2.50 × 10 -14 M
1.25 × 10-14 M
2.00 × 10-1 M
Flag question: Question 10Question 102 pts
A ligand is a molecule or ion that acts as a
Group of answer choicesLewis base.
Brønsted-Lowry base.
conjugate acid.
Arrhenius base.
Lewis acid.
Flag question: Question 11Question 112 pts
Calculate the pH of a solution that is 0.112 M in sodium formate (NaHCO2) and  in formic acid  The Ka of formic acid is 1.77 × 10-4.
Group of answer choices10.63
5.073
3.369
14.38
4.121
Flag question: Question 12Question 122 pts
A 700.0 mL sample of 0.18 M HClO4 is titrated with 0.27 M CsOH. Determine the pH of the solution after the addition of 350.0 mL of CsOH.
Group of answer choices1.52
0.68
2.35
12.48
3.22
Flag question: Question 13Question 132 pts
What is the pH of a 0.020 M Ba(OH)2 solution?
Group of answer choices1.70
1.40
12.60
13.20
12.30
Flag question: Question 14Question 142 pts
A solution contains Fe2+, Ba2+, Ag+, NH4+, and Cd2+. Identify the soluble compound after the addition of 6 M HCl; then H2S and 0.2 M HCl; then OH- to a pH of 8; and then (NH4)2HPO4 with NH3.
Group of answer choicesBa3(PO4)2
CdS
NH4Cl
FeS
AgCl
Flag question: Question 15Question 152 pts
Which of the following is a Lewis acid?
Group of answer choicesAlBr3
CHBr3
NH3
CCl4
None of the above is a Lewis acid.
Flag question: Question 16Question 162 pts
Calculate the Ksp for hydroxide if the solubility of Mn(OH)2 in pure water is 7.18 × 10-1 g/L.
Group of answer choices2.10 × 10-6
5.50 × 10-11
8.07 × 10-3
7.18 × 10-1
5.25 × 10-7
Flag question: Question 17Question 172 pts
What is the hydronium ion concentration of a 0.100 M hypochlorous acid solution with  The equation for the dissociation of hypochlorous acid is:
HOCl(aq) + H2O(l) ⇌ H3O+(aq) + OCl-(aq)
Group of answer choices5.9 × 10-4 M
1.9 × 10-5 M
1.9 × 10-4 M
5.9 × 10-5 M
Flag question: Question 18Question 182 pts
What is the pH of a solution made by mixing 29.00 mL of 0.10 M acetic acid with 29.00 mL of 0.10 M KOH? Assume that the volumes of the solutions are additive. Ka = for CH3CO2H.
Group of answer choices7.00
5.28
6.22
10.02
8.72
Flag question: Question 19Question 192 pts
Calculate the pH of a solution formed by mixing 150.0 mL of 0.20 M HClO with 300.0 mL of 0.30 M CsClO. The Ka for HClO is 2.9 × 10-8.
Group of answer choices6.46
5.99
7.06
7.54
8.01
Flag question: Question 20Question 202 pts
Calculate the pH of a 0.16 M carbonic acid solution, H2CO3(aq), that has the stepwise dissociation constants Ka1 = 4.3 × 10-7 and Ka2 = 5.6 × 10-11.
Group of answer choices3.58
10.25
6.37
0.80
Flag question: Question 21Question 212 pts
What is the hydroxide ion concentration of a NaOH solution that has a pH of 12.20?
Group of answer choices12.20 M
1.58 × 10-2 M
1.80 M
7.20
6.31 × 10-13 M
Flag question: Question 22Question 222 pts
Calculate the pH of a solution that is 0.322 M in nitrous acid (HNO2) and 0.178 M in potassium nitrite (KNO2). The acid dissociation constant of nitrous acid is 4.50 × 10-4.
Group of answer choices3.607
10.91
4.554
14.26
3.093
Flag question: Question 23Question 232 pts
What is the pH of the resulting solution if 45.00 mL of 0.10 M acetic acid is added to 10.00 mL of 0.10 M KOH? Assume that the volumes of the solutions are additive. Ka = 1.8 × 10-5 for CH3CO2H
Group of answer choices6.62
5.29
9.80
4.20
8.71
Flag question: Question 24Question 242 pts
Place the following in order of increasing acid strength.
HBrO2HBrO3HBrOHBrO4
Group of answer choicesHBrO4 < HBrO2 < HBrO3 < HBrO
HBrO < HBrO4 < HBrO3 < HBrO2
HBrO2 < HBrO4 < HBrO < HBrO3
HBrO < HBrO2 < HBrO3 < HBrO4
HBrO2 < HBrO3 < HBrO4 < HBrO
Flag question: Question 25Question 252 pts
Determine the pH of a 0.00444 M HClO4 solution.
Group of answer choices1.353
2.353
12.647
11.647
5.824
Flag question: Question 26Question 262 pts
A 6.0 × 10-3 M aqueous solution of Ca(OH)2 at 25.0°C has a pH of ________.
Group of answer choices5.6 × 10-13
12.08
1.92
11.78
1.2 × 10-2
Flag question: Question 27Question 272 pts
An aqueous solution at 25.0°C contains [H+] = 0.099 M. What is the pH of the solution?
Group of answer choices0.0990
1.00
13.0
-1.00
1.20 × 10-13
Flag question: Question 28Question 282 pts
Calculate the molar solubility of thallium chloride in 0.0.25 M NaCl at 25°C. Ksp for TlCl is 
Group of answer choices8.2 × 10-3 M
6.8 × 10-4 M
1.7 × 10-5 M
1.3 × 10-2 M
Flag question: Question 29Question 292 pts
Calculate the pH for an aqueous hydroiodic acid solution that contains  hydronium ion.
Group of answer choices11.50
2.50
12.50
3.17 × 10-12
3.15 × 10-3
Flag question: Question 30Question 302 pts
Describe what happens at high pH for aluminum hydroxide.
Group of answer choicesAl(H2O)23+ precipitates.
Al precipitates.
Al dissolves.
Al(H2O)2(OH)4- dissolves.
Al(OH)5 precipitates.
Flag question: Question 31Question 312 pts
Which of the following acids (listed with Ka values) and their conjugate base should be used to form a buffer with a pH of 2.34?
Group of answer choicesHClO2, Ka = 1.1 × 10-2
HIO, Ka = 2.3 × 10-10
HCN, Ka = 4.9 × 10-10
C6H5OH, Ka = 1.3 × 10-10
HN3, Ka = 2.5 × 10-5
Flag question: Question 32Question 322 pts
How many milliliters of 0.0991 M LiOH are required to titrate 25.0 mL of  to the equivalence point?
Group of answer choices0.208
4.58
29.5
21.2
0.333
Flag question: Question 33Question 332 pts
A solution contains Ba2+, Hg2+, Ag+, NH4+, and Fe2+. Identify the precipitate after the addition of 6 M HCl.
Group of answer choicesHgS
Ba3(PO4)2
FeS
AgCl
NH4Cl
Flag question: Question 34Question 342 pts
Identify the diprotic acid.
Group of answer choicesCH3COOH
HNO3
H2SO3
HClO4
HF
Flag question: Question 35Question 352 pts
Find the percent ionization of a 0.337 M HF solution. The Ka for HF is 3.5 × 10-4.
Group of answer choices4.7%
1.2 × 10-2%
3.2%
1.1%
3.5 × 10-2%
Flag question: Question 36Question 362 pts
Identify the weak monoprotic acid.
Group of answer choicesH2CO3
NaBr
HF
HNO3
LiOH
Flag question: Question 37Question 372 pts
Determine the pH of a 0.141 M RbOH solution at 25°C.
Group of answer choices13.86
13.15
0.141
0.851
0.88
Flag question: Question 38Question 382 pts
Calculate the pH of a solution that contains 7.8 × 10-6 M OH⁻ at 25°C.
Group of answer choices8.89
12.72
1.28
5.11
9.64
Flag question: Question 39Question 392 pts
What is the pH of a 0.300 M NH3 solution that has Kb = 1.8 × 10-5? The equation for the dissociation of NH3 is:
NH3(aq) + H2O(l) ⇌ NH4+(aq) + OH-(aq)
Group of answer choices10.89
2.11
11.37
6.22
2.63
Flag question: Question 40Question 402 pts
A 150.0 mL sample of 0.18 M HClO4 is titrated with 0.27 M LiOH. Determine the pH of the solution after the addition of 45.0 mL of LiOH.
Group of answer choices1.21
1.12
0.86
2.00
2.86
Flag question: Question 41Question 412 pts
Formic acid (HCO2H, Ka = 1.8 × 10-4) is the principal component in the venom of stinging ants. What is the molarity of a formic acid solution if 25.00 mL of the formic acid solution requires 74.80 mL of 0.0567 M NaOH to reach the equivalence point?
Group of answer choices0.170 M
0.0375 M
0.0190 M
0.0567 M
0.0134 M
Flag question: Question 42Question 422 pts
Which of the following acids (listed with pKa values) and their conjugate base should be used to form a buffer with a pH of 8.10?
Group of answer choicesHC7H5O2, pKa = 4.19
HF, pKa = 3.46
HClO, pKa = 7.54
H2SO3, pKa = 1.77
HClO2, pKa = 1.96
Flag question: Question 43Question 432 pts
Calculate the pH of a buffer that is 1.26 M HClO and 0.079 M NaClO. The Ka for HClO is 2.9 × 10-8.
Group of answer choices7.46
6.67
7.74
7.54
6.34
Flag question: Question 44Question 442 pts
A 550.0 mL sample of 0.18 M HClO4 is titrated with 0.27 M KOH. Determine the pH of the solution after the addition of 550.0 mL of KOH.
Group of answer choices1.35
12.85
12.65
13.13
0.87
Flag question: Question 45Question 452 pts
Calculate the pH of a buffer that is 0.080 M HF and 0.040 M NaF. The Ka for HF is 3.5 × 10-4.
Group of answer choices4.86
2.06
3.56
3.76
3.16
Flag question: Question 46Question 462 pts
Which one of the following salts, when dissolved in water, produces the solution with the highest pH?
Group of answer choicesCsCl
CsI
CsF
CsBr
Flag question: Question 47Question 472 pts
What is the pH at the equivalence point of a weak base-strong acid titration if 20.00 mL of NaOCl requires 28.30 mL of 0.40 M HCl to reach the equivalence point? Ka = 3.0 × 10-8 for HOCl.
Group of answer choices2.10
0.40
3.23
3.76
4.08
Flag question: Question 48Question 482 pts
A solution contains Zn2+, Hg2+, Ag+, NH4+, and Ba2+. Identify the precipitate after the addition of 6 M HCl, then H2S and 0.2 M HCl.
Group of answer choicesBa3(PO4)2
ZnS
NH4Br
AgCl
HgS
Flag question: Question 49Question 492 pts
A 220.0 mL sample of 0.20 M HF is titrated with 0.10 M NaOH. Determine the pH of the solution after the addition of 440.0 mL of NaOH. The Ka of HF is 3.5 × 10-4.
Group of answer choices3.46
8.14
7.00
9.62
10.54
Flag question: Question 50Question 502 pts
The largest change in pH for an effective buffer occurs when the base is how many times as concentrated as the acid?
Group of answer choices6
20
5
40
10

History homework help

 You will write an 10-12 pageresearch essay worth 300 points.The essay must be double-spaced, written in 12-point Calibri, Garamond, or Times New Roman font, with margins set at one inch.  The essay must be written in your best prose. It must be well-organized and grammatically correct.
You must support your points with specific references and direct quotations. You are required to directly quote and analyze at least one primary source document and at least five scholarly secondary sources (see “Project Planning: Annotated Bibliography” below). However, long block quotes should be used sparingly and only if absolutely necessary. Try to integrate your quotes and references into the logical and rhetorical flow of your essay. The purpose of this paper is to research and explore the life of a notable individual, organization, or movement of your choosing that is associated with the Christian tradition. The figure/movement may come from any time period of Christian history. Your paper should research, discover, and discuss the figure/movement’s historical context, origins/foundations, developments, ideologies, practices/rituals, influence on society, and significance to the Christian tradition. Overall, you will be graded on clear organization (60 pts); clear and persuasive thesis argument throughout (60 pts); supporting points with specific references (120 pts); and, spelling, syntax, and grammar (60 pts).
Make sure proper sources are used: below is access to the Fsu libraries database ..other databases can be used but this is my university.
https://www.lib.fsu.edu/find-database

English homework help

C.W.
In her poem “Oxygen”, Mary Oliver uses denotations and connotations to symbolize the meaning of oxygen. In this short poem, there are words and phrases that uses connation and denotation. The title “Oxygen”, contains connotations with life because everything needs oxygen in order to survive. Meanwhile, the author uses denotation by looking at different aspects of the poem. The author uses strong connotations that represents life. When Oliver describes her life, we are introduced to different words that relates back to her life. Oliver believes that oxygen is “the soul” (line 2). The soul is the part of you that will live on after death. It lives on in heaven and becomes immortal. This provides depth to the poem because this is associated with a person’s life. Another word that is associated with life is “Knife” (line 16), A “knife is a word that suggests a sharp and painful injury to any area of the body. This pain could be felt as a harmful way to Oliver’s life. This “knife could be a symbol, as she thinks that he life is harsh, and could be damaged emotionally. We can also admit that a knife is the meaning that signifies death, a sacrifice made, and liberation, and relates to a symbolic meaning of both words. Mary Oliver chooses these words very carefully as she decides what would be best to show her dedication to life itself. The words I have chosen adds reasonable meanings to the narrators dedication and gratitude towards her life, which is mentioned at the end of the poem. The gratitude and dedication was seen throughout the poem with the powerful word choices that resembles the authors life as her oxygen.
S.L.
In her poem “The Pond” Amy Lowell uses imagery to show the tranquility surrounding the pond. We start with talking about the leaves on the pond. The leaves are “Floating on moss-colored water” (line 2). The peace of being surrounded on the pond of these trees gives a sense of peace like no one is there. But there’s wildlife surrounding as she introduces “croaking of frogs” (line 3). There is nothing here to disturb the peace of this pond. The pond is peaceful through the “twilight” (line 4) of the night.

English homework help

 please review the link below and select one section to review. Specifically, under Intervention Settings/Locations, please select community, and then you can select any other filter you would like to individually review.
Link: https://wwwn.cdc.gov/chidatabase
Please address the following questions in a Word Document. You can address them in bullet-point form and you do not need to have complete sentences. 

  • Section selected
  • Relate the section to what we discussed on Monday. In other words, refer to the slides and the website I had you all read for Monday. For example, what behavior needs to be changed, what measurement instruments did they use, who does the intervention help…..You do not need to cover everything we discussed but I would say the three questions for the section should equal two pages. 
  • Reflect on the sections. How was the information communicated? Why? What would you do differently? Why?
  • attachment

    Day30_SC.pdf

Management homework help

Scenario (fictional):
An industry consulting firm has the following structure and culture:
All the employees at this consulting firm work full-time. All the full-time consultants report to various industry directors depending on the industry contract. The company employees work mostly from home with directors or consultants renting temporary office space with or without videoconferencing when needed for either client meetings or vendor meetings. The company is very successful and has an expanding client base.
The company CEO is extremely relaxed and extremely smart and expects everyone at the company to display a relaxed yet expert demeanor as well. There really are very few rules or expectations at the company as the CEO also believes in keeping processes very simple.
The previous president retired about six months ago, and the CEO, together with a human resources firm, hired a new president. About two months ago the company’s employees (i.e., consultants) started receiving emails from the new president putting pressure on all of them to produce results in less time but pressuring them to charge the clients higher sums without making any more money for themselves. In addition, the new president wants the staff to come into the office now three times a week for meetings. Three months ago the new president hired thirty new full-time consultants that seem more like salespersons than consultants to existing employees. A few of the long-time consultants have been emailing the CEO about these changes and suggesting they may go elsewhere. In the meantime, the Finance Director has detected several anomalies in the contract terms and financial results from some of the new consultants and one or two of the existing consultants.

  • Describe the organizational structure at this consulting firm and how it affects employee behavior.
  • Describe how the changes to the organization’s culture might affect employee behavior.
  • Provide a recommendation for any adjustments you think need to be made at this organization based on the Reading and explain why.

After checking your spelling and grammar, upload your minimum 250-word response in a WordⓇ document to the Unit 9 Journal Dropbox. Be sure to use APA format (i.e., 12-point Times New Roman font, double spacing, and 1 inch margins).

Economics homework help

A city’s administration isn’t driven by the goal of maximizing revenues or profits but instead looks at improving the quality of life of its residents. Many American cities are confronted with high traffic and congestion. Finding parking spaces, whether in the street or a parking lot, can be time consuming and contribute to congestion. Some cities have rolled out data-driven parking space management to reduce congestion and make traffic more fluid.
You’re a data analyst working for a mid-size city that has anticipated significant increments in population and car traffic. The city is evaluating whether it makes sense to invest in infrastructure to count and report the number of parking spaces available at the different parking lots downtown. This data would be collected and processed in real-time, feeding an app that motorists can access to find parking space availability in different parking lots throughout the city.
Instructions: Work with the provided Excel database. This database has the following columns:
LotCode: A unique code that identifies the parking lot
LotCapacity: A number with the respective parking lot capacity
LotOccupancy: A number with the current number of cars in the parking lot
TimeStamp: A day/time combination indicating the moment when occupancy was measured
Day: The day of the week corresponding to the TimeStamp
Insert a new column, OccupancyRate, recording occupancy rate as a percentage with one decimal. For instance, if the current LotOccupancy is 61 and LotCapacity is 577, then the OccupancyRate would be reported as 10.6 (or 10.6%).
Using the OccupancyRate and Day columns, construct box plots for each day of the week. You can use Insert > Insert Statistic Chart >Box and Whisker for this purpose. Is the median occupancy rate approximately the same throughout the week? If not, which days have lower median occupancy rates? Which days have higher median occupancy rates? Is this what you expected?
Using the OccupancyRate and LotCode columns,construct box plots for each parking lot. You can use Insert > Insert Statistic Chart >Box and Whisker for this purpose. Do all parking lots experience approximately equal occupancy rates?Are some parking lots more frequented than others? Is this what you expected?
Select any 2 parking lots. For each one, prepare as scatter plot showing occupancy rate against TimeStamp for the week 11/20/2016 –11/26/2016. Are occupancy rates time dependent? If so, which times seem to experience highest occupancy rates? Is this what you expected?
Presentation:
Create a 10- to 12-slide presentation with speaker notes and audio. Your audience is the City Council members who are responsible for deciding whether the city invests in resources to set in motion the smart parking space app.
Complete the following in your presentation:
Outline the rationale and goals of the project.
Utilize boxplots showing the occupancy rates for each day of the week. Include your interpretation of results.
Utilize box plots showing the occupancy rates for each parking lot. Include your interpretation of results.
Provide scatter plots showing occupancy rate against time of day of your selected four parking lots. Include your interpretation of results.
Make a recommendation about continuing with the implementation of this project.