Based on the provided excel file, answer the attached questions in paragraph format and include all required graphs and formulas please.
1. Using Microsoft Excel, use the pivot table function to answer the following questions?
a. What were the total sales ($) in all regions for 2016?
b. What were the top two regions in total sales dollars for
c. What region sold the most units in 2016?
2. Using Microsoft Excel, use the pivot table function to answer the following questions?
a. What were the total sales ($) in all regions for 2017?
b. What were the top two regions in total sales dollars for
c. What region sold the most units in 2017?
3. Who are the top 3 sales representatives by $ for 2015, 2016 and 2017 combined?
4. Who are the bottom 3 sales representatives by $ for 2015, 2016 and 2017 combined?
5. Best-selling item of 2015 by units sold
6. Best-selling item of 2015 by ($)
7. Best selling item of 2016 by units sold
8. Best selling item of 2016 by ($)
9. Best selling item of 2017 by units sold
10. Best selling item of 2017 by ($)
11. Using a Line Graph, Plot Sales in ($) by month for 2015, 2016 and
12. Using a Line Graph, Plot Sales in units by month for 2015, 2016 and
a. Explain the overall sales trends from 2015 to 2017?
b. What items sold more?
c. What items sold less?
d. How do the 2017 sales compare to 2016 sales ($)?
e. How do the 2017 sales compare to 2015 sales ($)?
13. Based on Q1 of sales data Is 2018 on track to be better or worse
year, compared to year X in terms of:
a) Units sold for each year 2015, 2016 and 2017
b) Revenue for each year 2015, 2016 and 2017
14. Provide a forecast for total sales ($) for 2018. What is the basis for this forecast? Explain?
There is dependably approaches to get help when somebody needs it. They can do as such by calling the secret National Domestic Hotline (DMVH) at 1-800-799-SAFE (7233), they are accessible to the United States, 24 hours, 7 days seven days, and open 365 days a year. The DMVH have advisors to help them in getting them data and referrals for themselves, their kids, protect, and legitimate help (Michigan State Police). There are numerous different things that you could do to help a casualty or even a casualty herself can do. It might be similarly as simple as getting a telephone directory to discover what associations in your group assist with, for example, business or even tyke mind. There are other distinctive things that should be possible, for example, looking for guiding or even care groups. While you are looking for advising, ensure you distinguish climate the instructor is for the mishandled and has had understanding of working with the manhandled. Above all else remain dynamic however much as could be expected to help your confidence, fearlessness, and getting you freedom back (Women Web, Getting Help). Aggressive behavior at home sanctuary, frequently called a ladies' haven is a building or set of lofts where casualties of manhandle can look for shield. These asylum areas are kept private so these ladies' abusers can't discover them. Safe houses are known to furnish those manhandled and their youngsters with haven, nourishment and childcare. Since there are exceptionally constrained circumstances for dwelling at a safe house, numerous asylums aid arrangement of lasting homes and occupations (Help manage). There are diverse things that should be possible subsequent to leaving a haven so their abuser doesn't discover them. The best 3 things that you can do are: 1.) get and unlisted number, 2) utilize a P.O. Box, 3.) open new financial balances and Mastercards (Help manage). In the wake of finding how genuine Domestic brutality really was, the Domestic Violence Bill, 2006 was passed. The Domestic Violence Bill was proposed to permit more help and alleviation of the mishandle. The reason for this Bill was to permit those associated with abusive behavior at home the most extreme security that the laws can give. These laws have made it compulsory for all police headquarters to have particular offices to manage and give lawful obligation on the officers to aid a protest abusive behavior at home. Under the arrangement of this bill, cops are assume to educate the casualty with respect to their rights under, help in getting cover, offer therapeutic treatment, and to stop a criminal grumbling. The Domestic Violence Act additionally enables cops to capture the charged culprit, without a warrant who is sensibly suspected to have conferred or who is debilitating to submit a demonstration of aggressive behavior at home on a casualty. On the off chance that any individual is captured they are to be brought before a justice inside forty-eight hours (Government Gazette) Once in a while, individuals have been known to state," What would they be able to do to enable somebody they to realize that is being manhandled?" There are a wide range of arrangements that individuals can do to help those in require that are engaged with an aggressive behavior at home relationship. As indicated by the Michigan State Police there are different arrangements engaged with helping somebody. Comprehending what one is discussing by having some foundation on abusive behavior at home. Continuously let them realize that your ears are open at whenever they have to talk. Help them however much as could reasonably be expected by being aware, understanding and steady in finding out about their security. In conclusion, never let them think it is their blame, continue tending to that however much as could be expected. Under the Michigan Constitution, (Art. I, Sec. 24; eff. Dec. 24, 1988) and the Crime Victim's Rights Act, (1985 PA 87; MCL 780.751) have given wrongdoing casualties the privilege to be treated with nobility and regard. Ensuring all is dealt with in an auspicious way following a capture. The casualty likewise has the privilege to get crisis and restorative administrations. Get a clarification of all court procedures. This demonstration enables them to be ensured of being free of any dangers, demonstrations, as well as release from your boss. The name of the Prosecutor's who is taking care of the case. Any booked court procedures, including condemning, the litigant's discharge on bond or escape from guardianship while anticipating trial. The probation offices address and phone number. Go to the court trial and put forth an oral expression to a pre-sentence specialist, and to compose an effect explanation which will be incorporated into the pre-sentence report. Casualties are additionally permitted to get data with respect to the conviction, sentence, detainment, and arrival of the charged. (Michigan Prosecuting Attorney Associations). There are various impacts of the mishandle. On the off chance that somebody had physical manhandle they may experience the ill effects of long haul wellbeing entanglements. Mishandled ladies frequently have nervousness, pressure, low vitality, discouragement, a sleeping disorder, loss of hunger, or even migraines. They may trust that they fizzled the relationship. They have additionally been known to be embarrassed and not enabling others to know precisely what had transpired. In pretty much every instance of Domestic Violence, ladies have expressed that they have lost their confidence and absence of certainty. Ladies have likewise been known to have outrage and dread towards themselves and their abuser. They are additionally known to segregate themselves from other, for example, family and companions (Women's Web, The Effect of Abuse). As indicated by Direnfeld (2007), the outcome of enthusiastic and mental can keep going for quite a while or even lifetime. It influences the casualty as well as other relatives and later connections. Much of the time, youngsters have the injury of the savagery. These kids develop to end up spooks in their own particular right whose conduct the damaged parent can't control and whose conduct is strengthened by the culprit. There are numerous things that a casualty needs to recollect, it's difficult to do everything without a moment's delay. Between the police, and safe houses, the casualty has other they can converse with; rather it is an advisor or even somebody that has experienced it. There primary concern they have to know what are their rights? References Direnfeld, G. MSW, RSW (2007). Alumbo, the Long Arm Of Domestic Violence. Recovered July 24, 2009 from http://www.alumbo.com/article/32544-The-Long-Arm-Of-Domestic-Violence.html Government Gazett (2006). Aggressive behavior at home Bill, 2006. Recovered July 22, 2009 from http://www.kubatana.net/docs/legisl/dom_viol_bill_060630.pdf Help control (2008). Aggressive behavior at home and Abuse: Help, Treatment, Intervention, and Prevention Retrieved July 24, 2009 from http://www.alumbo.com/article/32544-The-Long-Arm-Of-Domestic-Violence.html Michigan Prosecuting Attorney Associations (2008). Casualty Rights. Recovered July 20, 2009 from http://www.michiganprosecutor.org/Victim.htm Michigan State Police (2009). Abusive behavior at home Awareness. Recovered July 20, 2009 from http://www.michigan.gov/msp/0,1607,7-123-1589_1711_4577 - ,00.html Ladies Web (2009). Abusive behavior at home, The Effect of Abuse. Recovered July 25, 2009 from http://www.womensweb.ca/brutality/dv/effects.php Ladies Web (2009). Abusive behavior at home, Getting Help. Recovered July 25, 2009 from http://www.womensweb.ca/brutality/dv/help.php>GET ANSWER