Sleep Study

I am going to upload an excel spreadsheet that I am working on. The whole point of this project is to do nestedifs, lookups , sumifs , sumaverages. The professor gave me feedback and said that its looking good. The only thing its missing is some data charts and the sumifs, averageifs, nestedifs, date/time functions stuff like that .  The website where I got the information is  https://www.ncbi.nlm.nih.gov/pmc/articles/PMC5536318/
I cant figure this out . I did a vlookup but its needing more .  For the most part its done, I just need those data charts and excel functions.
i.    An IF() function with An AND() or OR() function
ii.    Date/Text functions
iii.    A VLOOKUP() or HLOOKUP()function
iv.    A COUNTIFS(), SUMIFS(), AVERAGEIFS() type function

Species Extinction from Human Destruction

Argument  research paper for writing 121 .  Need 3 sources and 1 for argument 
My thesis :is: 
  Human Destruction in the fourth coming years including pollution, will soon be the driving factor leading species to extinction.

I need a question  as this is a thesis,  argumentive  research paper. 

  I also  I believe that humans (we) are the cause of the animal extinction
You can use other sources to but at least use a couple of mine. Thank you

Sephora Business Model

Develop an analysis of the Business Model of SEPHORA (BirchBox MAJOR COMPETITOR).
While doing this analysis, answer the following questions:
– What was the opportunity for disruption the firm spotted, and was it obvious that it was there?
– Were there other opportunities they didn’t pursue?

The analysis should be done relating or having some sort of connection/comparison with Birch Box characteristics of business model.

Attached you can find resources to base the task on, based on BirchBox and Sephora.

https://services.hbsp.harvard.edu/api/courses/719345/items/912010-PDF-ENG/sclinks/4f859dc7a41413536797c22b89ab69ad
https://digital.hbs.edu/platform-digit/submission/sephora-vs-birchbox-winning-through-digital-retaliation/

Also, feel free to use this ones to analyze sephora’s business model. IMPORTANT TO FOCUS ON THE SUBSCRIPTION BASED MODEL. Feel free to use other resources if  they have important and UPDATED information.

https://www.digitalcommerce360.com/2015/08/12/sephora-signs-beauty-box-subscription-model/https://etailwest.wbresearch.com/how-sephora-integrates-retail-online-marketing
https://etailwest.wbresearch.com/how-sephora-integrates-retail-online-marketing
https://digital.hbs.edu/platform-rctom/submission/sephora-behind-the-scenes-of-the-beauty-behemoth/
https://www.cbinsights.com/research/report/sephora-teardown/

Treating Trauma

This week, we consider the many options for treatment in disaster situations.

Using the course materials as a guide, identify the treatment option(s) you would deploy in a specific disaster situation, explaining your rationale for the selection(s).
In addition, discuss the population(s) the treatment will be used with and why this is the most appropriate choice for the population(s) identified.