How can preparation of a preliminary marketing plan be beneficial for a big and small business?

Respond to the following in a minimum of 175 words each

1.What are your thoughts regarding preparation of a preliminary marketing plan?

2.How can preparation of a preliminary marketing plan be beneficial for a big and small business?

3. After a business starts to spiral downward, is it too late to develop a beneficial marketing plan?

Multiuse High Rise Buildings

There are two questions that you have to answer it. initial posts should be between 150-500 words. ( I attached the document and there are different discussions from other students, and you have to Respond to at least three peer comments.)

Question 1: Multiuse High Rise Buildings

Multi-use highrise buildings are appearing with increasing frequency and pose interesting decisions for design professionals and regulatory authorities. Assume you are responsible for reviewing the design for such a large building. How would you approach the problem of setting requirements when there are multiple types of occupancies in the same building? The problem is not as simple as requiring fire-rated partitions between the different types of occupancies within the same building. Many of the issues concern human and organizational factors. Especially important is how the occupancies interact regarding exiting requirements. What if a building has an assembly occupancy on it’s second floor. Would you permit the theater patrons to leave using the main building entrance? If you required that most of the patrons leave using exits dedicated to the theater, how would you assure that they would use those exits instead of the main entrance?

Students Answer/

Student 1:

To start, the building will need to be designed with a Fire Alarm  System, and program to provide a phased evacuation (Notify floor of origin, the floor above, the floor below); the notification system will need to be voice communication with general selective paging for each floor. Secondly, the fire sprinkler system will need to be designed per the particular occupancy for each floor, with automatic standpipes (Class 1) in the stairwells and an automatic sprinkler on the landings in the stairwell. Third, transitional refuge areas (fire-rated pressurized spaces at various locations in particular for occupancies). Fifth, stairwell pressurization systems. Sixth, the stairwell egress must be wide enough between 66 -72 inches and strong enough to support phased evacuation.

With answering the questions

Yes, I would permit the patrons to leave through the main building entrance, I feel that many people in the theater will begin to backtrack how they entered the building, and we need to make sure we house the egress available for them to do so. However, I would provide alternate route and illuminate those routes when the fire alarm system does alarm as well making sure the staff responds to the alarm and assist with the evacuation.

Student 2:

In a multi occupanci building I think that I need to aprroch the situation in different way for every bilding.I think that more than use the main factor is how much peopl I need to evacuate. If I have a theater, I wuold create special doors for the evacuation just for them. The rapidly increse of people if they are going out for the general evacuation route, willl decrease the walking speed. If they go out out for that special doors, I will mantain the waliking speed in every part of the building. To asure that they will use those door, befero the show start I will put somethin that anounce whete are the emergency exits, I will put them in the side of the stage. 

Student 3:

The use of mutli use buildings requires looking at the different occupant loads and hazards of each type of use. There needs to be an examination of how different occupants of each facility are expected to act. There are expected to be occupants in the assembly occupancy  which need to be accounted for as oppose to possibly a supply facility with few occupants. For the assembly I would permit patrons to use the main entrance as that may be the safest at the time and its inevitable that some will retrace the route they entered. Each theater will have available exit points from within the theater that should be attempted to be used and I will ensure that they are properly identified and locations announced prior to each presentation. 

Student 4:

Performing plan reviews for a large building such as a high rise with multiple uses inside, one must start at the site where this large building will be constructed. Before this construction goes vertical, a lot of requirements must be met on the ground with adequate roadways, access roads, water mains and hydrants. Performance based design options are now used per floor of this high-rise to meet the current codes for egress requirements, number of exits, corridor widths, allowable fire areas through fire-rated partitions, smoke partitions in egress stairwells, fire-rated doors with magnets to close in an emergency to prevent smoke from spreading throughout, emergency lighting and exit signage elements, portable fire extinguishers all of which are code based upon the intended uses on each floor. Let’s not forget the fire sprinkler system required and the addressable fire alarm system too. These are requirements based upon fire codes and NFPA. Depending on the water flow and pressure into the building, a fire pump or pumps will more than likely be required to provide adequate pressure and volume to the upper floors of this high rise. Standpipe systems will also be required in the stairwells for firefighting operations out and to remote areas of the individual floors. If the building has an assembly area on the second floor, then with the designed use of active fire protection for life safety (fire sprinkler system), then allowances are given for corridor lengths are given, but HVAC systems and building ventilation design is required to be tied into the fire alarm which will trigger the building’s ventilation to remove smoke and exchange air to the outside of this high-rise. So, a discussion will ensure with the architect and engineers to determine if the current design warrants the additional capital of additional exits from the second floor or if current exits and egress paths are adequate with the fire protection systems to satisfy the architect’s performance-based design while meeting the code requirements for this design. 

Student 5:

The risks associated with residential high rise buildings (buildings over 6 stories) are countless to say the least. Most of these building have very effective fire suppression systems and detection beyond the floor involved. Adding a assembly on the second floor will not only increase the occupant load but require an effective plan for evacuation for all floors above due to convergence with escape routes. This starts the conversation of a phased evacuation where the main fire floor is evacuated and notified first. The stairwells in a mixed use occupancy, will need to be protected with a pressurized stairwell and fire sprinkler suppression systems and wide enough that the convergence of individuals can make egress accessible. In the case of a movie theatre, patrons will be willing to use the entrance as an exit but for this reason an alternate path should be used and staff should coordinate the evacuation plan with well-lit exit signs. A voice notification system should be used to alert all occupants of what floor will be involved.

Student 6:

1. When a building is of mixed occupancy or used for more than one occupancy, the whole building shall be subject to the most restrictive requirement pertaining to any of the 
   type of occupancy found therein except in the 
   following:
2.  When a one-story building houses more than one occupancy, each portion of the building shall conform to the requirement of the particular occupancy housed therein and;
   (2) Where minor accessory uses do not occupy more than ten percent of the area of any floor or a building, nor more than ten percent of the basic area permitted in the occupancy requirements, in which case, the major use of the building shall determine the occupancy classification.

Forms Of Occupancy Separation

1. Occupancy separations shall be vertical or horizontal or both, or when necessary, of such other forms as may be required to afford a complete separation between the various occupancy divisions in the building.

Types of Occupancy Separation

1. Occupancy separation shall be classified as “One-Hour Fire-Resistive”, “Two-Hour Fire-Resistive”, “Three-Hour Fire-Resistive” and “Four-Hour Fire-Resistive.”
2. A “One-Hour Fire-Resistive Occupancy Separation” shall be of not less than one-hour fire-resistive construction.  All openings in such separation shall be protected by a fire assembly having a one-hour fire-resistive rating
3.  A “Two-Hour Fire-Resistive Occupancy Separation” shall be of not less than two-hour fire-resistive construction.  All openings in such separation shall be protected by a fire assembly having a two-hour fire-resistive rating.
4. A “Three-Hour Fire-Resistive Occupancy Separation” shall be of not less than three-hour fire-resistive construction.  All openings in walls forming such separation shall be protected by a fire assembly having 
   a three-hour fire-resistive rating.
5. The total width of all openings in any three-hour fire-resistive occupancy separation wall in any 
   one-story shall not exceed 25 percent of the length of the wall in that story and no single 
   opening shall have an area greater than 10square meters.  All openings in floors forming a “Three-Hour Fire Resistive 
   Occupancy Separation” shall be protected by vertical enclosures extending above and 
   below such openings. 
6. The walls of such vertical enclosures shall be of not less than two-hour fire-resistive construction, and all 
   openings therein shall be protected by a fire assembly having a three-hour fire-resistive 
   rating.
7. A “Four-Hour Fire-Resistive Occupancy 
   Separation” shall have no openings therein and shall be of not less than four-hour fire-
   resistive construction.
    

Fire Rating for Occupancy Separation

1. Occupancy Separations shall be provided between groups, subgroupings, or divisions of occupancies.  The Secretary shall promulgate rules and regulations for appropriate occupancy separations in buildings of mixed occupancy; Provided, that, where any occupancy separation is required, the minimum shall be a “One-Hour Fire-Resistive Occupancy Separation”; and where the occupancy separation is horizontal, structural members supporting the separation shall be protected by an equivalent fire-resistive construction.

Question 2: Bias Towards Familiar Egress Routes and Implications for the Fire Alarms

This second question builds off of Question 1this week. Keep in mind that people show a strong bias toward using familiar egress routes. What are the implications for a fire alarm system? Would you want the fire alarm system to operate differently for different parts of the building? If there was a day care facility within this building that helped serve those individuals that worked in the building, what problems would you expect?  Would you expect parents to try to reach the day care center before evacuating the building? What recommendation would you make to encourage parents not to travel to the day care center?

Students Answer/

Student 1:

Yes, I would want the fire alarm to operate differently for a high-rise building by providing a phased evacuation (Notify floor of origin, the floor above, the floor below)

If there is a daycare in the building, there are many issues. One example, there is usually one teacher to about eight toddlers, so trying to get eight toddlers downstairs by yourself with other adults trying to go down the stairs will be a failure. Another example is the issues with the handrails and steps that are in a stairwell.

Yes, I would expect parents to try to reach the daycare before evacuating a building. As a parent, it will be difficult to stop me or, better yet, my wife from getting my kids if we know there is a fire in a high-rise building. The recommendation is to make sure each parent knows the evacuation process for the daycare, and if they impede it will slow the evacuation down.

I want to add additional content about the daycare in a high-rise building. I think it is essential when or if the design is created for the building; the daycare should be placed closest to the ground level. Also, it would be ideal for the daycare to have its own elevator or stairwell to exit. If that is not possible, at minimum, the area or zone will need to be fully sprinklered and to be designed as a transitional refuge area. Finally, the daycare staff needs to be notified soon as an event happens so that staff can start their fire evacuation plan.

Student 2:

This is one difficult situation to work, the people noramally wait to go out, think what it go to happend if they have a kid inside the building. The implication fortheis alamr,are that need to be something really loud and anoying, something that make the people want to go out. Also, add coice direction dirrecting to the emergency doors. In the day care, I think that it need to be a bit quiet, I willl want to just let know to the teachers or the adults in the day care, I wil prefer have the kids in oreder, instead take a couple of more seconds. The systems need to operate different because every profile from the biulding will reacyt diffeent to the alarm.In the day care I would expect the teacher getting out with all the children,and the hall crwod try to pass. To solve this I would have a special route for the kids. Yes, I wuold expect the parents at some point reach for the kids, this can be a problem if the need to go in opposite directions in relation of the crowd. I will recomend give to the parents the hall plan of during a evacuation, detail per detail. WIth this I looking to let them know where the go to be after the evacuation. 

Student 3:

With people attempting to use familiar egress routes this would affect the alarm system by using phased evacuation by attempting to egress the ones in most severe danger to prevent a bottle neck of occupants. For the day care system I would ensure that all workers are fully aware of the evacuation procedures as well as a designated safe rally point for all children. I would also make sure that all parents that utilize the day care are clearly made aware of the dayscares evacuation procedures as well as the rally point where they can locate children instead of attempting to make access to children through the building. 

Student 4:

People are in fact creatures of comfort and like water will follow the path of least resistance. On a floor in a building with multiple uses such as a large assembly and a daycare, the fire alarm system would in fact notify everyone. In an assembly, large crowds of people will naturally assimilate and head to the same entrance / exit in which they arrived at the space. Best case, they may head to the closest exit by following the person in the front of them. In a daycare on the same floor, some children depending on their age may get excited or become frantic from the sound of the fire alarm system. They will be swept up by the teachers or aides in the classroom and then all will exit the building according to and as they were instructed. Once outside, an accountability system will take effect and the teachers and aides will account for all the children before notifies are made to parents if the event kept all occupants out of the building for an extended period of time.  

Student 5:

First off, people that are not familiar with buildings will tend to use the same way they came in . That being said when a fire alarm goes off, people will converge to the entrance with the highest density. Using voice communication systems in the parts of the building can help with evacuation when children are involved in a daycare facility. Parents will inherently want to ensure their children’s safety in the event of a fire. For this reason parents will try to make access to their children but a well-planned evacuation system where the parents can meet in a safe haven should be used. This gives a chance for the daycare facility to operate with known plans and accountability, plus reduce that panic of parents showing up and grabbing kids without anyone noticing. Parents and daycare officials can meet in a safe haven area and start a process for an orderly pick up. These evacuation procedures like I say in all of my posts “ should be trained on and reevaluated”. Fire drills are not just for kids.

Student 6:

In terms of the day care center, i would try and make room for it to be on the first floor so that it is easier for the employees of the day care to evacuate the children. In terms of making sure that the parents dont go to the day care before exiting i belive that there should be two seperate entrances so that you have to go outside to get to the day care’s entrance. This would make sure that people exit first and that the day care employees can focus on getting the kids out instead of worrying about the parents coming back in and possibly getting in the way. 

Create an original Titration Problem and Solve it Correctly

Write a Titration Problem (Weak – Strong) – Before, At and After Equivalence. Create a powerpoint presentation explaining the problem solving process. Give tips and advice for how to approach the problem. What mistakes can be made and how to avoid them. Be creative and think about what would work for you.

You submission should include a Systematic Plan to solve the problem using diagrams/pictures/charts to explain each step while correctly answering the problem.Grading Rubric:

• Create an original Titration Problem and Solve it Correctly – 10 points
• Creatively explain and answer the Before Equivalence Process – 10 points
• Creatively explain and answer the At Equivalence Process – 10 points
• Creatively explain and answer the After Equivalence Process – 10 points
• Images/Diagrams/GIFS/Charts – 10 points

write a stored function named fHW_10_xxxx () which will return the total payment amount for a given student ID and a year. Please refer to Students, Courses, Students_Courses tables. Assume each credit is $100.

TECH3740/2021 Fall Homework Name:__________________  Section 01 due date: 11:59pm 12/1/2021. Section 04 due date: 11:59 pm 12/6/2021  Total 120 points. Late penalty: 20 points off/week.  No resubmission after receiving the score. Please indicate your complete status on the Blackboard.  Please note that xxxx is your Kean email ID in this homework.  Please create your tables, views and stored routines under TECH3740_2021F database.  Please refer dreamhome database for questions 3 – 10.  Note: The example output is for reference only. The example output might have the different values than real database. DO NOT hard code the values, all the values should be retrieved/calculated from the database. Part I: Please evaluate, analyze and answer the following questions. 1. _ (15 pts) Create one new table Courses_xxxx. Your table names must follow the above format (table name is case sensitive) with following fields in correct data types. This table will be used in your project.  cid: auto_increment integer, primary key (2 pt)  name: varchar(200), unique, NOT NULL (2 pt)  term: varchar(200), NOT NULL (1 pt)  enrollment: int, NOT NULL (1 pt)  Fid: int, NOT NULL, a foreign key to TECH3740.Faculty table. (3 pts)  Rid: int, NOT NULL, a foreign key to TECH3740.Rooms table. (3 pts)  aid: int, NOT NULL, a foreign key to TECH3740.Admin table. (3 pts)

2. _ (10 pts) insert 5 records into your Courses_xxxx table The fid, rid, aid should not be all the same among the 5 records. The enrollment number should be less than the room size. 3. _ (5 pts) Write a view named vHW_3_XXXX to show the total room number for each hotel that has 3 or more rooms. The output columns should be hotelname, number_of_rooms and it should be sorted based on the total room number from high to low. You should use the Hotel and Room tables in dreamhome database. Here is a sample output. +———–+—————–+ | hotelname | number_of_rooms | +———–+—————–+ | Latham | 3 | | Grosvenor | 3 | +———–+—————–+
3. _ (5 pts) Write a view named vHW_4_XXXX to list the hotel name, total rooms in the hotel, total revenue if all rooms were booked for the hotel, and the revenue is higher than 85, also the hotels are in London. Your view header names should be: hotelname, count, revenue. You should use Hotel and Room tables in dreamhome database. Below is a sample of the output. +—————+——-+———+ | hotelname | count | revenue | +—————+——-+———+ | Omni Shoreham | 2 | 89.98 | | Grosvenor | 3 | 87.00 | +—————+——-+———+ 5. _ (5 pts) Create a view vHW_5_xxxx to list the project name, staff name and the staff’s branch city for the same staff who working on the same project more than one time. You should use Project, Staff2, Branch, and Working tables. The output column header should be (Project_name, Staff_name, Branch_city). The staff_name should combine fname and lname with a space in between. Below is a sample output: +—————–+————–+————-+ | Project_name | Staff_name | Branch_city | +—————–+————–+————-+ | Kean University | New Engineer | London | | Citi Bank | Susan Brand | Glasgow | | British Museum | Super User | London | +—————–+————–+————-+
   Page 2 of 3 6. (10 pts) Create a view vHW_6_xxxx to show the employee who has the lowest salary for each gender. You must use UNION operation and Staff2 table in the dreamhome database. The output column name should be (gender, name, age, salary). The name should be combined fname and lname, with a space in between. The output should be female first and then male. Below is a sample output: +——+————+——+———+ | sex | name | age | salary | +——+————+——+———+ | F | Mary Howe | 51 | 9000.00 | | F | Julie Lee | 56 | 9000.00 | | M | New Tester | 31 | 8000.00 | +——+————+——+———+
4. (10 points) Create a view vHW_7_xxxx listing staff’s names, salary, ages, and their supervisors’ names, salary, and ages for all staff whose supervisor’s age is older than the staff’s age and their supervisor’s salary is higher than the staff’s salary. You should use Staff2 table. The output header needs to distinguish between staff and manger: (E_name, E_position, E_salary, E_age, M_name, M_position, M_salary, M_age). Below is a sample output. +———+———-+——-+———+———-+——-+ | E_fName | E_salary | E_age | M_fName | M_salary | M_age | +———+———-+——-+———+———-+——-+ | Susan | 24000.00 | 81 | John | 30000.00 | 75 | +———+———-+——-+———+———-+——-+
   Part II: Write Stored Routines. Grading criteria is based on the test cases for each question. xxxx is your database login ID. The email ID of the testing statements is demo.
5. (20 points) Please write a stored procedure named pHW_8_xxxx( city ) which will display the student’s transcript by a student’s first_name and last_name. The transcript should have the student’s first_name, last_name, all courses ID, course names and grades at which year/semester. Please refer to Students, Courses, Students_Courses tables.
   8.1 (5 pts) > call pHW_8_demo(‘Austin’, ‘Huang’); The above SQL statement should have output:
   8.2 (5 pts) > call pHW_8_demo(‘Tim’, ‘Smith’); The above SQL statement should have output:
   8.3 (5 pts) > call pHW_8_demo(null,’Smith’); The above statement should have output:
   8.4 (5 pts) > call pHW_8_demo(‘Tim’,”); The above statement should have output:
6. (20 points) Please write a stored function named fHW_9_xxxx() which will return the course id that the course name contain a given parameter pattern string. You must use LIKE for the pattern match. Please refer to Courses table. 9.1 (5 pts) > select fHW_9_demo(‘Z’) as output; The above SQL statement will return 9.3 (5 pts) > select fHW_9_demo(”) as output; The above SQL statement will return
   Page 3 of 3
   9.2 (5 pts) > select fHW_9_demo(‘M’) as output; The above SQL statement will return.
   9.4 (5 pts) > select fHW_9_demo(null) as output; The above SQL statement will return
7. (20 points) Please write a stored function named fHW_10_xxxx () which will return the total payment amount for a given student ID and a year. Please refer to Students, Courses, Students_Courses tables. Assume each credit is $100.
   10.1(5 pts) > select fHW_10_demo(2000,1001) as output; The above SQL statement will return
   10.2 (5 pts) > select fHW_10_demo(2016,1001) as output; The above SQL statement will return.
   10.3 (5 pts) > select fHW_10_demo(”, 1002) as output; The above SQL statement will return
   10.4 (5 pts) > select fHW_10_demo(2017, null) as output; The above SQL statement will return

Write dowm the difference equation for the infinite impulse response filter having z-transform H(z) = 1+0.9z−1 1−0.5z−12 = Y (z) X(z)

Problem 1

1. Derive the Fourier transform Xr(f) ∈C of a modulated rectangular pulse train xr(t)+ej2π1txr(t−4τ) where xr(t) is a rectangular pulse having height A and duration τ [15 pts] 2. Find the Fourier transform of x(t) = cos(2πf0t) + αxr(t)2 [15 pts].

Problem 2

1. If x(n) and h(n) are discrete sequences, write the mathematical definition of y(n) = x(n) ⋆ h(n) where ⋆ is convolution [5 pts]
2. Use the above definition to show that y(n) = [h1(n)+h2(n)]⋆x(n) is equal to h1(n)⋆x(n)+h2(n)⋆x(n) [5 pts]
3. A 3-port discrete-time LTI system has two inputs and one output, with impulse response from input k to output y(n) given by hk(n). If h1(n) = {1,0.5,−1,0,0,…} and h2(n) = {1,1,1,−1,−1,−1,0,0,…}, find the transform domain relationship Y (z) =Pk Hk(z)Xk(z) using the impulse responses. Assume inputs are denoted by z-transform pairs (xk(n),Xk(z)), where (n,z) ∈ Z,C,k = 1,2. Here n is time index, and z is the z-domain complex variable [10 pts]
4. Find the frequency domain relationship between the Fourier transforms of the two inputs and the output by evaluating the z-domain relation on the unit circle z = ejω [10 pts].
   Problem 3
5. A system produces y(t) when driven by x(t) via the transfer function y(t) = 100x(t−τ −τ2 + 10τ3). Here, τ is a constant time delay. Is this a linear or non-linear system? [10 pts] 2. A system produces Y (f) when driven by X(f) via the Fourier transfer function Y (f) = X(f)e−jγf2. Is this an LTI system? [10 pts] 3. A system produces y(t) when driven by x(t) via the transfer function y(t) =Rt λ=−∞ x(λ)dλ. What is the output for βx(t) where β ∈R. [10 pts] 4. Write dowm the difference equation for the infinite impulse response filter having z-transform H(z) = 1+0.9z−1 1−0.5z−12 = Y (z) X(z) [10 pts]
   1

Give reasons, when average cost increases as the total output increases for an increasing cost industry.

Assignment 3

Release Date: November 21, 2021     Deadline: November 30, 2021 @23:59pm

For Instructor’s Use only

 PLEASE READ THEM CAREFULLY

• This assignment is an individual assignment.
• Due date for Assignment 3 is 30/11/2021).
• The Assignment must be submitted only in WORD format via allocated folder.
• Assignments submitted through email will not be accepted.
• Students are advised to make their work clear and well presented. This also includes filling your information on the cover page.
• Students must mention question number clearly in their answer.
• Late submitted assignments will NOT be entertained.
• Avoid plagiarism, the work should be in your own words, copying from students or other resources without proper referencing will result in ZERO marks. No exceptions.
• All answered must be typed using Times New Roman (size 12, double-spaced) font. No pictures containing text will be accepted and will be considered plagiarism).

Submissions without this cover page will NOT be accepted.

Assignment 3                                                                       Maximum Marks-05

Question 1:

1. A monopoly occurs when there are barriers entering the market. List 3 types of these barriers with explanation and example. (1 Mark)
2. Fill the following table for a monopolist firm. (1 Mark)

•  Draw the demand curve and the marginal revenue curve for the above table. And explain the relationship between the marginal revenue and the price. (1 Mark) 

Question 2.

1. Explain the effects of low price-guarantee on the price. (1 Mark)
2. Give reasons, when average cost increases as the total output increases for an increasing cost industry. (1 Mark)

Explain the effects of low price-guarantee on the price.

 PLEASE READ THEM CAREFULLY

• This assignment is an individual assignment.
• Due date for Assignment 3 is 30/11/2021).
• The Assignment must be submitted only in WORD format via allocated folder.
• Assignments submitted through email will not be accepted.
• Students are advised to make their work clear and well presented. This also includes filling your information on the cover page.
• Students must mention question number clearly in their answer.
• Late submitted assignments will NOT be entertained.
• Avoid plagiarism, the work should be in your own words, copying from students or other resources without proper referencing will result in ZERO marks. No exceptions.
• All answered must be typed using Times New Roman (size 12, double-spaced) font. No pictures containing text will be accepted and will be considered plagiarism).

Submissions without this cover page will NOT be accepted.

Assignment 3                                                                       Maximum Marks-05

Question 1:

1. A monopoly occurs when there are barriers entering the market. List 3 types of these barriers with explanation and example. (1 Mark)
2. Fill the following table for a monopolist firm. (1 Mark)

•  Draw the demand curve and the marginal revenue curve for the above table. And explain the relationship between the marginal revenue and the price. (1 Mark) 

Question 2.

1. Explain the effects of low price-guarantee on the price. (1 Mark)
2. Give reasons, when average cost increases as the total output increases for an increasing cost industry. (1 Mark)

Using the new variable for charge per day , is there a difference in charge per day among patients in Alameda, Sacramento, and Santa Clara Counties?

Assignment #5 – Using SPSS to Analyze Health Data

Due: Wednesday, December 8, 2021, 4:00 PM

It is preferred that students work in pairs on the assignment, with one assignment submitted per pair; both students in a pair will receive the same grade. It is strongly recommended that both students actively participate in preparing the assignment. If, instead, partners choose to split the assignment (with each being responsible for different parts of the assignment), be aware than one person’s poor/non-completion of his/her portion is NOT an acceptable reason for submitting the assignment late. You may work with a student in the Wednesday section; if you do, please note that when you upload your assignment. (Although Assignment 1 is due at a later date for the Wednesday section, your assignment is due on your due date.)

To complete this assignment, you will need the following files:

a)            Your SPSS data file (.sav file) used in Assignment 4

b)            OSHPD Documentation

c)            CA County Codes

The OSHPD Documentation and CA County Codes can be found on the Assignment 5 page.

INSTRUCTIONS – READ CAREFULLY

These instructions apply to all parts of Assignment 5. Points are associated with all instructions; not following the instructions will result in a loss of points and can have a significant impact on your grade.

Copy the results from your SPSS output file into a Word document. (Add your answers and output to this document.) All answers should be in complete sentences. Statistical tests must include complete interpretations along with the SPSS output.

Name the Word document as follows:  OurLastNamesFirst Initials_Assign5.docx (or MyLastNameFirst Initial_Assign5.docx), where you replace OurLastNamesFirst Initials (or MyLastNameFirst Initial) with your first initials and last names (e.g., WolfJ_LoboJ_Assign5.docx). Your name(s) must be a part of the file name. Please also type your name(s) at the top of the Word document. Your SPSS data file (.sav file) should be named in the same way as the Word document. Upload both the Word document and your SPSS data file (.sav file) to Canvas on the Assignment 5 page.

You must include the log that describes the recoding of all variables needing to be recoded and all syntax used to answer the questions. Your SPSS data file (.sav) should match your answers. (In other words, I should be able to run the analyses from your SPSS file and get the same results you report.) You are required to type the values into the variable view of the SPSS file for all variables that you use, including the original variables you recode; your interpretations must use the category names and not simply the codes used in SPSS.

Read each question carefully.

Question 1  (15 points)

Is there a difference in charges (use the “NewChg” variable you created in Assignment 4) between Los Angeles and San Diego Counties?

A.   Run the appropriate statistical test to answer this question.

B.   Write a complete interpretation of the results of this analysis.

C.   Show the results table(s).

D.   Include value labels for all variables as appropriate.

E.   Show the log for the statistical test.

Question 2  (12 points)

Is there a relationship between sex and scheduled and unscheduled admissions (“adm_type”)?

A.   Use all cases.

B.   Run the appropriate statistical test to answer this question.

C.   Write a complete interpretation of the results of this analysis.

D.   Show the results table(s).

E.   Include value labels for all variables as appropriate.

F.   Show the log for the statistical test.

 Question 3  (19 points)

Using the new variable for charge per day (ChargeDay that you created in Assignment 4), is there a difference in charge per day among patients in Alameda, Sacramento, and Santa Clara Counties?

A.   Run the appropriate statistical test to answer this question.

B.   Write a complete interpretation of the results of this analysis.

C.   Show the results table(s).

D.   Include value labels for all variables as appropriate.

E.   Show the log for the statistical test.

Question 4  (14 points)

Is there a relationship between age (in years), charges, and length of stay? Use age_years, NewLOS, and NewChg.

A.   Use all cases.

B.   Run the appropriate statistical test to answer this question.

C.   Write a complete interpretation of the results of this analysis.

D.   Show the results table(s).

E.   Show the log for the statistical test.

why firms bother to enter such a market?

In perfectly competitive markets long-term economic profit is zero. If so, why firms bother to enter such a market

In a perfectly competitive market, there are no barriers to entry and firms can enter and leave the market depending on their profits.

NOTE:

1. Post your 300-400-word answers earn a maximum of 14 points.
2. Offer at least two 200-300-word comments (replies) to posts from your peers’ discussions by earn a maximum of 8 points each

Requirements: 300-400

Create a text file in which to store hyperlinks to your home page and PHP scripts. Turn in this file to the appropriate submission box

Create web pages for your database using PHP. You should have one page that will return all the information from the database. You should create additional pages that will allow you to do various queries of your database. You should be able to retrieve and insert data; also include functionality to delete data from your database. I will be looking for these features. Feel free to handle those functions however you feel is best for your project.

Create an html form that will allow you to enter in new information for the database. The information should be handled by a PHP script that will take the data and input it into the database.

The interface doesn’t have to look real pretty at this point. That will be done in the next phase. If you want to go ahead and make things look nice, feel free to do so.

If you have not yet created a home page, create a separate home page that contains links to each of the web pages you create to access your database. Your database (must have a minimum of two tables) is not to be displayed on the home page; be creative on this page. On each of the database pages create a button (link) to go back to the home page. Your project must have more than one page; your home page should have links to other pages to perform operations on the database. Some appropriate picture or image should be on the home page that relates to you project. Make your project look as professional as possible. You may want to show it during a interview.

Create a text file in which to store hyperlinks to your home page and PHP scripts. Turn in this file to the appropriate submission box