AimThe purpose of assignment 2 is to prepare a dataset with which you can conduct data analyses for the term project. This is related to the term project, but please note that this assignment should be individual work. Also, you need to explore some variables that can be used as a dependent variable and independent variables. More details will be explained below.DatasetFor the project phase 1 report, you already selected a medical condition of your group’s interest, and there should be more than 500 data instances. For the assignment 2, please think about your research question(s). With that being said, you need to explore variables in your dataset. You can change those variables later, but this assignment will help you better understand the dataset. Please visit the official website (Links to an external site.) and Github repository (Links to an external site.) and read the attached appendix document Download attached appendix document(p.1 – 13). MEPS data consists of various variables such as medical condition, socioeconomic factors (e.g., gender, region, race, and family income), and medical expenditure. MEPS data also consist of various files such as person-level (e.g., health status, demographics, and total $$ of care), event-level (e.g., healthcare service use), and condition-level (e.g., medical condition). For the full review of those variables, please look at codebooks (person-level (Links to an external site.)) and condition-level (Links to an external site.)). I also coded those variables (personal-level only) regarding usefulness for analysis (included vs. excluded, Heejun_Inclusion field) and variable type (independent vs. dependent, Heejun_Variable_Type field). You can find my version of the codebook from this link (Links to an external site.). Some dependent variables you can utilize includes but are not limited to:Total health expendituresTotal inpatient expendituresTotal emergency care expendituresSeverity of Illness (attacks/year)Number of School Days Missed (Children)Number of Work Days Missed (Adult)For now, just focus on personal-level (h129.csv) and condition-level (h128.csv) files for exploring variables. At least, find one dependent variable and five core independent variables that can be used for the group project by carefully looking at documents and websites above. The selected independent variables should not be randomly selected. They should be clinically related to your dependent variable.The second step is to preprocess your dataset. Please utilize the “week6_example_code.ipynb” notebook for this process. You need little modification to complete data processing and integration. Select patients (h128.csv) with the your medical condition, drop attributes which are not necessary, and join the condition-level data (h128.csv) and personal-level data (h129.csv).What to Do for the Assignment 2Explore the dataset and find one dependent variable and five core independent variables at leastExplain what these variables are and how they are related to the medical condition of your interestPreprocess your data. The preprocessing will include but are not limited to:h128.csvSelect records that are related to your condition of interest by using ICD-9 code and drop duplicated records based on the ‘DUPERSID’ (rowwise selection)h129.csvSelect attributes that are discriminative and/or meaningful (columnwise selection)Join two files (h128.csv and h129.csv) after selecting patient instances with the medical condition of your interestHow to writeFor the assignment 2, I will not put constraints on the format. However, you need to present, at least, one dependent variable and five core independent variables. Also, please explain what these variables are and how they are related to the medical condition of your interest. Up to this part, you can write the report in a MS word file. You also need to submit your Jupyter notebook you used for data preprocessing and the final data file (csv).What to includeYour submission of the report should include:Your nameEUIDTitle of the projectWhat I asked you in the “How to Write”Please attach a .docx file for the report and .ipynb and .csv files for the data processing. Again, this is an individual assignment.Grading CriteriaYour reports will be evaluated on the quality of entries. By quality, I do not mean mechanics (e.g., spelling, grammar), but rather content. Your entries should demonstrate reflective and critical thinking, integration of materials and experiences, development of your own research questions, and general intellectual growth. Also, I will look at the data preprocessing steps you implemented.

AimThe purpose of assignment 2 is to prepare a dataset with which you can conduct data analyses for the term project. This is related to the term project, but please note that this assignment should be individual work. Also, you need to explore some variables that can be used as a dependent variable and independent variables. More details will be explained below.DatasetFor the project phase 1 report, you already selected a medical condition of your group’s interest, and there should be more than 500 data instances. For the assignment 2, please think about your research question(s). With that being said, you need to explore variables in your dataset. You can change those variables later, but this assignment will help you better understand the dataset. Please visit the official website (Links to an external site.) and Github repository (Links to an external site.) and read the attached appendix document Download attached appendix document(p.1 – 13). MEPS data consists of various variables such as medical condition, socioeconomic factors (e.g., gender, region, race, and family income), and medical expenditure. MEPS data also consist of various files such as person-level (e.g., health status, demographics, and total $$ of care), event-level (e.g., healthcare service use), and condition-level (e.g., medical condition). For the full review of those variables, please look at codebooks (person-level (Links to an external site.)) and condition-level (Links to an external site.)). I also coded those variables (personal-level only) regarding usefulness for analysis (included vs. excluded, Heejun_Inclusion field) and variable type (independent vs. dependent, Heejun_Variable_Type field). You can find my version of the codebook from this link (Links to an external site.). Some dependent variables you can utilize includes but are not limited to:Total health expendituresTotal inpatient expendituresTotal emergency care expendituresSeverity of Illness (attacks/year)Number of School Days Missed (Children)Number of Work Days Missed (Adult)For now, just focus on personal-level (h129.csv) and condition-level (h128.csv) files for exploring variables. At least, find one dependent variable and five core independent variables that can be used for the group project by carefully looking at documents and websites above. The selected independent variables should not be randomly selected. They should be clinically related to your dependent variable.The second step is to preprocess your dataset. Please utilize the “week6_example_code.ipynb” notebook for this process. You need little modification to complete data processing and integration. Select patients (h128.csv) with the your medical condition, drop attributes which are not necessary, and join the condition-level data (h128.csv) and personal-level data (h129.csv).What to Do for the Assignment 2Explore the dataset and find one dependent variable and five core independent variables at leastExplain what these variables are and how they are related to the medical condition of your interestPreprocess your data. The preprocessing will include but are not limited to:h128.csvSelect records that are related to your condition of interest by using ICD-9 code and drop duplicated records based on the ‘DUPERSID’ (rowwise selection)h129.csvSelect attributes that are discriminative and/or meaningful (columnwise selection)Join two files (h128.csv and h129.csv) after selecting patient instances with the medical condition of your interestHow to writeFor the assignment 2, I will not put constraints on the format. However, you need to present, at least, one dependent variable and five core independent variables. Also, please explain what these variables are and how they are related to the medical condition of your interest. Up to this part, you can write the report in a MS word file. You also need to submit your Jupyter notebook you used for data preprocessing and the final data file (csv).What to includeYour submission of the report should include:Your nameEUIDTitle of the projectWhat I asked you in the “How to Write”Please attach a .docx file for the report and .ipynb and .csv files for the data processing. Again, this is an individual assignment.Grading CriteriaYour reports will be evaluated on the quality of entries. By quality, I do not mean mechanics (e.g., spelling, grammar), but rather content. Your entries should demonstrate reflective and critical thinking, integration of materials and experiences, development of your own research questions, and general intellectual growth. Also, I will look at the data preprocessing steps you implemented.

Assessing and Treating Patients With Sleep/Wake DisordersSleep disorders are conditions that result in changes in an individual’s pattern of sleep (Mayo Clinic, 2020). Not surprisingly, a sleep disorder can affect an individual’s overall health, safety, and quality of life. Psychiatric nurse practitioners can treat sleep disorders with psychopharmacologic treatments, however, many of these drugs can have negative effects on other aspects of a patient’s health and well-being. Additionally, while psychopharmacologic treatments may be able to address issues with sleep, they can also exert potential challenges with waking patterns. Thus, it is important for the psychiatric nurse practitioner to carefully evaluate the best psychopharmacologic treatments for patients that present with sleep/wake disorders.Reference: Mayo Clinic. (2020). Sleep disorders. https://www.mayoclinic.org/diseases-conditions/sle…To prepare for this Assignment:Review this week’s Learning Resources, including the Medication Resources indicated for this week.Reflect on the psychopharmacologic treatments you might recommend for the assessment and treatment of patients with sleep/wake disorders.The Assignment: 5 pagesExamine Case Study: Pharmacologic Approaches to the Treatment of Insomnia in a Younger Adult. You will be asked to make three decisions concerning the medication to prescribe to this patient. Be sure to consider factors that might impact the patient’s pharmacokinetic and pharmacodynamic processes.At each decision point, you should evaluate all options before selecting your decision and moving throughout the exercise. Before you make your decision, make sure that you have researched each option and that you evaluate the decision that you will select. Be sure to research each option using the primary literature.Introduction to the case (1 page)Briefly explain and summarize the case for this Assignment. Be sure to include the specific patient factors that may impact your decision making when prescribing medication for this patient.Decision #1 (1 page)Which decision did you select?Why did you select this decision? Be specific and support your response with clinically relevant and patient-specific resources, including the primary literature.Why did you not select the other two options provided in the exercise? Be specific and support your response with clinically relevant and patient-specific resources, including the primary literature.What were you hoping to achieve by making this decision? Support your response with evidence and references to the Learning Resources (including the primary literature).Explain how ethical considerations may impact your treatment plan and communication with patients. Be specific and provide examples.Decision #2 (1 page)Why did you select this decision? Be specific and support your response with clinically relevant and patient-specific resources, including the primary literature.Why did you not select the other two options provided in the exercise? Be specific and support your response with clinically relevant and patient-specific resources, including the primary literature.What were you hoping to achieve by making this decision? Support your response with evidence and references to the Learning Resources (including the primary literature).Explain how ethical considerations may impact your treatment plan and communication with patients. Be specific and provide examples.Decision #3 (1 page)Why did you select this decision? Be specific and support your response with clinically relevant and patient-specific resources, including the primary literature.Why did you not select the other two options provided in the exercise? Be specific and support your response with clinically relevant and patient-specific resources, including the primary literature.What were you hoping to achieve by making this decision? Support your response with evidence and references to the Learning Resources (including the primary literature).Explain how ethical considerations may impact your treatment plan and communication with patients. Be specific and provide examples.Conclusion (1 page)Summarize your recommendations on the treatment options you selected for this patient. Be sure to justify your recommendations and support your response with clinically relevant and patient-specific resources, including the primary literature.Note: Support your rationale with a minimum of five academic resources. While you may use the course text to support your rationale, it will not count toward the resource requirement. You should be utilizing the primary and secondary literature.

I have an interview coming up and I really want to impress the interviews, so I need 10 questions to the ask the interviews about firm.I want the 10 questions to be interesting because it will show that I am interested in working for the firm. I really want this job!!! Also, can you also write me a brief summary of the firm does. The summary should not be anymore than 2 sentences. Here is the link for the company https://www.eidebailly.com/Here is the job description and company.Typical Day in the LifeA typical day as an Administrative Assistant might include the following:Utilize Engagement software to complete a wide range of tasks.Work with management to ensure that all documents are properly formatted and prepared according to Firm and/or client-specific guidelines.Prepare and assemble reports, company materials and client documents as directed.Manage and prioritize incoming work flow to meet all deadlines in a deadline-focused environment.Make arrangements for various meetings via conference calls, video conference and webcasts.Process expense reports for partners and managers.Responsible for engagement scheduling.Coordinate catering for meetings.Make travel arrangements for auditors.Perform a wide range of general administrative duties for the audit and tax departments and office.Perform backup receptionist duties as needed. Answer and direct incoming calls and greet clients.Work together with the entire Administrative team to ensure project deadlines are met and workload is evenly dispersed.Regular and predictable attendanceAssist management with client billingsProcess electronic or paper copies of client income tax return forms and documents and place on company portalDemonstrate an ability to multi-taskOpen to new challenges and assist with special projects as requestedRun office errands when necessaryWho You AreYou thrive in a high-volume, fast-paced work environment.You are a multi-tasking master, and there has never been a deadline you could not meet.You hold yourself to the highest professional standards and maintain strict client confidentiality.You are highly proficient in Microsoft Office (Word, Excel and Outlook).You have strong written and verbal communication skills.You are able to work overtime when needed.You love collaborating and being part of a team but also enjoy working alone with limited supervision.In addition to all of this, you have an Associate’s degree or 2 years of past administrative support experience.Must be authorized to work in the United States permanently without the requirement of sponsorship at any point in the future.Benefits And CompensationThe hourly rate range for this position is $20.00-$25.00/hr.Benefits for the position will include Medical, Dental, and Vision.What To Expect NextWe’ll be in touch! If you look like the right fit for our position, one of our recruiters will be reaching out to schedule a phone interview with you to learn more about your career interests and goals. In the meantime, we encourage you to check us out on Facebook, Twitter, Instagram, LinkedIn or our About Us page.Who We AreEide Bailly is one of the top 25 CPA and business advisory firms in the nation, serving 54,000 clients. We have 29 offices in 13 states across the Midwest and western United States, and offer our staff and Partners the opportunity to serve a variety of industries. Founded in 1917, our culture is the foundation of who we are, and we pride ourselves on supporting our employees to help them achieve their goals and pursue their interests both in the office and at home. At Eide Bailly we are passionate about the clients we serve, the work we do, and most importantly, having fun while we do it!Why You’ll Love Working HereAt Eide Bailly we believe respect is how to treat everyone, not just those you want to impress. Our culture focuses on collaboration to achieve career growth. Innovation is highly encouraged, which is where programs like our EB Xchange originate. This program allows interested tax and audit employees to complete a rotation in a specialty area. We promote happy employees by making work/life balance a priority along with being actively involved in our communities. Our dedication to service can be seen through the Firm’s decision to match charitable donations made by employees, as well as providing opportunities to volunteer throughout the year. Most importantly, we like to have fun! We offer a professional and fun work environment with frequent free lunches, snacks, lunch and learns, socials, contests, outings and other events.Equal Opportunity Employer Minorities/Women/Protected Veterans/Disabled

TWO topics are required for Week 6. Topic 1 is required for everyone. Choose Topic 2, 3 OR 4. Include at least two (2) references from learning material or outside sources. Reply to least two (2) classmate posts.TOPIC 1: Pricing Strategies (Required)The readings suggest there are certain strategies for pricing new products, which is decidedly more difficult than adjusting prices to existing products. The new product pricing approaches are: Skimming Penetration Everyday low pricesThe pricing approaches discussed for existing products are: Cost plus Markup Markdown Odd-even pricing Prestige pricing Price lining Demand backward pricing Leader pricing Sealed bid pricing Going-rate pricing Price bundling Captive pricing Product mix pricing Two-part pricing Promotional pricingThere is no shortage of pricing approaches, and as customers, we are exposed to all of them at some time or another in our purchasing processes.Choose one of the pricing approaches and discuss the product, the pricing approach, and why you think it is the most appropriate approach for that particular product given your consumer characteristics. Be sure you understand the definition of your approach before tackling this topic. Many of you will be tempted to use promotional pricing since it is the easiest to demonstrate. So promotional pricing is not “for sale” (pun intended). Pick one of the other approaches for this topic. . Remember, there are no rights or wrongs in this topic. Each of us as consumers can view pricing differently.TOPIC 2: Channel SystemsThe Coca-Cola company has a very large and complex channel distribution system. Take a look at how the company describes its distribution system by clicking on this link.Coca-Cola system. (n.d.). The Coca-Cola Company. http://www.coca-colacompany.com/our-company/the-coca-cola-systemCan you outline the indirect channel system based on the information on the website? You might want to refer to Figure 8.4 or Figure 8.5 in the readings to organize your thoughts. What value does each of the channel members provide to the end customer? What might you suggest they do differently?TOPIC 3: Channel StrategiesThis section of the readings explains the three generic distribution strategies: Intensive Selective ExclusiveThe choice of which of these distribution strategies would be best for any given product depends on those factors outlined in the readings as follows: Type of customer Type of product Channel partner capabilities Business environment and technology Competing products’ marketing channelsPick a product for one of the three distribution strategies. Note your product and the distribution strategy, and then discuss why you feel the distribution strategy is most appropriate for that product based on the factors listed above. For example, Lexus automobiles are distributed selectively. Customers tend to be upper middle class who want an affordable (as they define it) luxury car that is highly dependable. Because of the service component, dealerships need to be all-inclusive for services needed for a Lexus and be as close to their target market as possible, e.g., upscale neighborhoods. But because Lexus is a car dealership, it can’t be directly located in an upscale neighborhood. The car dealer needs to be able to serve a geographic area that is easy to reach and where customers are willing to drive, and the best choice may be locations visible from highways driven by upscale members of the target market as they drive between home, work, and errands. A Lexus dealership wants to be located near competitive offerings to ensure the target market considers Lexus. It also makes it easy to shop the competition and to increase the value of the brand by being associated with like products. Do not use Lexus!Do the same type of description for each of the three distribution strategies with a product of your choice. TOPIC 4: Warehouse & TransportationOne way that manufacturers can reduce the price of a product is by decreasing the warehousing and transportation costs using the demand and inventory planning techniques discussed in Section 6.6 of the main text. This adds value to the customer.Warehousing and transportation tends to be outsourced by most manufacturers so they don’t have to develop those core competencies. Sometimes the warehousing or transportation channel member becomes the channel leader. Can you think of an example of a product for which the warehouse or the method of transportation is the channel leader? You might need to do a little web searching to find examples. Think creatively for both online delivery and physical delivery.