Excel Assignment 2
shawezdk8
QMBS_3360-600_Fall2020.pdf
QMBS 3360-600, Business Statistics II, Spring 2021, CRN: 22610
Department of Accounting & Finance, College of Business
Course Syllabus
Class Modality: Online Asynchronous
Class Meetings and Time: No scheduled meetings. Upload pre-recorded lectures, power point
notes and other videos regularly
Class Duration: 01/19/2021 - 05/11/2021
Instructor: Dr. Anurud Rankoth
Tel: 210-784-2700
E-Mail: [email protected]
Students email will receive a reply within 2 business days
Course Website: https://tamusa.blackboard.com/
Office Hours: Saturday 3.00pm – 6.00pm via Zoom
Catalog Course Description: This course is a continuation of Business Statistics I. This series explores
descriptive and inferential statistical techniques for business and economic decision making. Building on
the concepts and applications learned in QMBS/BUAD 2305, this course focuses on statistical concepts
including, but not limited to, hypothesis testing, goodness-of-fit, tests of independence, analysis of
variance (ANOVA), linear and multiple regression, and time series.
Course Objectives: The objective of the course is to provide the student with knowledge of the
statistical methods to solve different types of business problems
Prerequisites: QMBS/BUAD 2305 with a grade of ‘C’ or better.
Student Learning Outcomes:
After successful completion of this course, students will be able to:
1. To statistically describe data in a frequency distribution table.
2. To statistically describe data in a variety of graphs
3. To statistically describe measures of location and dispersion
4. To be able to construct a probability distribution discretely
5. To be able to construct a probability distribution normally
6. To be able to apply and construct sampling methods and sampling distributions
7. To be able to develop and test hypothesis
8. To be able to apply correlations and regression
AACSB Assessment: The College of Business is in the process of applying for AACSB accreditation.
As part of that process, students will be assessed on program level outcomes based on course outcomes
from various courses. The materials from this course may be used for assessing such program level
outcomes, and hence students must follow the necessary rigor to ensure mastery and retention of the
above course outcomes.
QMBS 3360-600, Business Statistics II, Spring 2021, Syllabus, Dr. Anurud Rankoth 2 | P a g e
COVID-19 Safety Protocol: Due to the current pandemic environment, all university personnel
(faculty, students and staff, etc) are required to adhere to mandated procedures and guidelines as
communicated through university communications. For details and updated information on COVID-19
safety protocol please visit https://www.tamusa.edu/community-safety-together/index.html.
Required Materials:
▪ Textbook: Business Statistics and Analytics in Practice, 9th Edition, by Bruce L. Bowerman; Ruth M. Hummel; Anne M. Drougas; Kyle B. Moninger; William Duckworth; Patrick J. Schur; Amy G.
Froelich. The textbooks are NO longer part of the fees included in Tuition & Fees starting this Spring 2021 semester. Students have to purchase the textbook on their own from the bookstore.
▪ Calculator: A calculator (preferably TI-36x) you may NOT use your phone. ▪ Blackboard: Connect to http://tamusa.blackboard.com. You will have lecture notes, solutions to
problems, multimedia materials and other supplementary materials in Blackboard.
▪ Connect: In addition to the assignments in Blackboard, you will complete quizzes, exams and assignments in an online homework management system Connect. Instructions on how to obtain
online access and a link to the website will be provided separately. Please ensure that you have purchased the appropriate code and register in the system ASAP.
▪ Computer Hardware: In order to participate in online sessions you will need a computer with an internet connection, a microphone and speakers/headphones. To complete the class work, you will
need appropriate software installed on the computer.
▪ Time Expectation for coursework: You are expected to spend 4-8 hours per week for the course.
Based on the background, some student may require more time. Time spent may be longer when
assignment/exams are due.
Other Recommended / Reading Materials: Additional reading materials will be available on the
course website as recommended by the instructor.
Course Requirements every student must fulfill in order to succeed in course: 1. Students should check the Course Calendar, Announcements, and Messages (e-mail) systems in Blackboard
on a regular basis.
2. Students should keep current with all course assignments, quizzes, and examinations. 3. If the course uses remote proctoring for exams, students must schedule their exam early in the semester. 4. Students should ask questions and communicate with the instructor either in class, online, off-line or during
office hours.
5. For all classwork, exams, quizzes etc., if a student is completing it off-campus, then they are responsible for availability of internet connectivity. Extensions will not be granted for lack of availability of internet
connections.
6. Students should remember that online courses assume greater responsibility and independent learning skills by the student for their own learning outcomes.
7. For online courses, students should keep current on class recordings, if not attending the live class (either in person or online).
8. For online asynchronous courses, there will be no online class sessions. All materials will be made available
through Blackboard or through online links.
QMBS 3360-600, Business Statistics II, Spring 2021, Syllabus, Dr. Anurud Rankoth 3 | P a g e
9. For online synchronous courses, there will be online class sessions as indicated. Students are expected to
attend the online session at the given time. If a student is unable to attend a session, instructor will make the
recording of the session available for the student to view. All materials will be made available through
Blackboard or through online links.
10.
Grading Policy: The final course grade will be based on your performance on the quizzes, exams,
assignments, and projects using the following weights:
Participation 05%
Homework Assignments 20%
Quizzes 10%
Term Project 15%
Midterm 20%
Final Exam 30%
The final letter grades will be assigned as follows: Above 90% A; 80 – 89% B; 70 – 79% C; 60
– 69% D; Below 60% F.
Examinations and Quizzes: There will be a mandatory mid-term exam and a mandatory final exam.
Being absent for an exam will result in a grade of zero for that exam and may result in a fail grade in the
course. Students NOT taken at the time a quiz is given will be marked absent and get a grade of zero.
The exams/quizzes will consist of conceptual multiple-choice questions, problem solving questions, and
short essay questions. The exam/quiz materials will come from lecture notes, the text, and class
discussions. Questions will emphasize understanding and applications of concepts and topics covered in
class.
Proctored Exams: Examinations in this class may/will be administered using secure online testing
services. Details regarding proctored test sign up and administration will be provided at least 2 weeks
prior to the exam.
Homework Assignments: There will be homework assignments assigned from the chapter each week
to allow you to practice the concepts.
Term Project: There will be one term project during the course. Can be done individually or as a group with NO
more than 3 students. Will be discussed more details in the class.
Make up and Late Assignment/exam/quiz policy: As a general rule, make-ups or late submissions
will NOT be offered or accepted for any missed assignments/exams. Late submissions or make-ups may
be accepted/administered only in extra-ordinary circumstances such as an excused official university
activity, a severe illness, or a dire emergency. However, you must provide comprehensive
documentation either before or within a few days of the missed assignment/exam.
Class conduct and civility code: Everyone in class is expected to follow all rules in the student
handbook, as well as common courtesy during classroom lectures and discussions in class and online,
including the following:
1. Attendance may be taken by an appropriate method by the instructor. 2. It is the students’ responsibility to obtain and be able to use the required materials and software
for this class.
QMBS 3360-600, Business Statistics II, Spring 2021, Syllabus, Dr. Anurud Rankoth 4 | P a g e
3. Student must retain copies of all assignments and graded work for verification purposes and provide it to the instructor, if necessary. Keep own copies of all computer files and e-mails until
final grade is received.
4. Talking while the instructor is lecturing is extremely disruptive and discourteous to the instructor and other students.
5. Using computers or phones (except for a valid urgent need) during class for a purpose not related to class is disruptive. All cell phones and gadgets should be turned OFF.
6. For any questions about the exams and assignments, a student should contact the instructor, well in advance of the day they are due, so the instructor may have enough time to provide feedback.
7. All communications will be via e-mail communications to the Texas A&M University e-mail account, and students are expected to use their school provided email account. The instructor will
reply to a student e-mail messages and voice messages within 2 business days (Monday-Friday).
8. All assignment submissions must be uploaded as instructed by the due date and time. Submission window may close or marked late, if not uploaded on time and be penalized for it.
Anyone violating these policies may be subject to disciplinary actions.
Class attendance and Participation: A vital part of every student's education is regular attendance of
class meetings (for synchronous classes) OR regular review of class materials posted by the instructor
(for asynchronous classes). Any absences tend to lower the quality of a student's work, and frequent or
persistent absences may result in a failing grade. Students are responsible for the materials covered in
class. The course covers a lot of material and most students find at least some parts of it difficult.
Students are strongly encouraged to ask questions, participate in class discussions and problem solving,
and visit/contact the instructor during office hours in case of questions or concerns. Good attendance and
participation may be rewarded when final grades are assigned.
The course is intensive and challenging and you are expected to master the materials presented in class.
The structure of the class makes your individual study and preparation outside of class extremely
important, and may vary considerably based on student background. However, a minimum of two hours
of work outside the class is expected for every one hour of class period per week. Reading the assigned
chapter(s) and having some familiarity with them before class will be very useful for understanding
lectures.
University Email Policy and Course Communications: All correspondence between professors and
students must occur via tamusa email accounts or Blackboard messages. You must have your Jaguar
email account ready and working. If it is not working, contact the help desk at 210-784-4357.
Academic Misconduct Policy: Texas A&M University-San Antonio students are expected to exhibit a
high level of honesty and integrity in their pursuit of higher education, and follow the Texas A&M
University-San Antonio Code of Conduct. For more information please visit the Office of Student
Rights &Responsibilities website http://bit.ly/TAMUSAStudentRR.
Academic misconduct includes, but is not limited to, cheating, plagiarism, multiple submissions,
collusion, lying and bribery. In cases of academic misconduct, students may be subject not only to grade
sanctions in courses but to disciplinary action. If a student wishes to appeal the decision of suspension or
expulsion due to violations of academic misconduct, they must initiate their appeal as outlined within
the Student Code of Conduct.
QMBS 3360-600, Business Statistics II, Spring 2021, Syllabus, Dr. Anurud Rankoth 5 | P a g e
All student term papers and other written assignments are subject to analysis by anti-plagiarism
software. Posting of any class work given to student, or solutions, or discussion, on publicly accessible
forums or on social media is not permissible unless explicit written permission have been granted by the
instructor.
Fall 2020 QMBS 3360-600 Class Schedule
The provisions and information set forth in the schedule below are intended to be informational and not
contractual in nature. The instructor reserves the right to amend, alter, change, delete or modify the
provisions of the schedule.
Week Begin Topic
1 1/19 Syllabus, Review of prior chapter concepts
2 1/26 Continuation of Review of prior chapter concepts
3 2/2 Chapter 9 Confidence Intervals
4 2/9 Chapter 9 Confidence Intervals
5 2/16 Chapter 10 Hypothesis Testing
6 2/23 Chapter 11 Statistical Inferences Based on Two Samples
7 3/2 Chapter 12 Experimental Design and Analysis of Variance
8 3/9 Review and Mid Exam
9 3/16 Chapter 13 Chi Square Tests
10 3/23 Chapter 14 Simple Linear Regression Analysis
11 3/30 Chapter 15 Multiple Regression and Model Building
12 4/6 Chapter 15 Multiple Regression and Model Building
13 4/13 Chapter 16 Predictive Analytics: Logistic Regression, Discrimination
Analysis, and Neural Networks
14 4/20 Chapter 17 Time Series Forecasting and Index Numbers
15 4/27 Chapter 17 Time Series Forecasting and Index Numbers (May 1, Last
Day of Classes)
16 May 3,4 Reading Days – Classes do NOT meet. Absolutely Nothing Due
16 May 5-11 Final Exam – Must be held only as per University Schedule.
IMPORTANT POLICIES AND RESOURCES
Academic Accommodations for Persons with Disabilities: The Americans with Disabilities Act
Amendments Act (ADAAA) of 2008 and the Rehabilitation Act of 1973 are federal anti-discrimination
statutes that provide comprehensive civil rights protection for persons with disabilities. Title II of the
ADAAA and Section 504 of the Rehabilitation Act require that students with disabilities be guaranteed
equal access to the learning environment through the provision of reasonable and appropriate
accommodation of their disability. If you have a diagnosed disability that may require an
accommodation, please contact Disability Support Services (DSS) for the coordination of services. The
phone number for DSS is (210) 784-1335 and email is [email protected].
Academic Learning Center: All currently enrolled students at Texas A&M University-San Antonio
can utilize the Academic Learning Center for subject-area tutoring. The Academic Learning Center is an
appointment based center where appointments are made through the Navigate platform. Students access
Navigate through Jagwire in the Student Services tab. The Center is active on campus outreaching to
students to highlight services offered. You can contact the Academic Learning Center by emailing
QMBS 3360-600, Business Statistics II, Spring 2021, Syllabus, Dr. Anurud Rankoth 6 | P a g e
[email protected] or calling (210)-784-1332. Appointments can also be made through JagWire under
the services tab.
Counseling Resources: As a college student, there may be times when personal stressors interfere with
your academic performance and/or negatively impact your daily functioning. If you or someone you
know is experiencing life stressors, emotional difficulties, or mental health concerns at Texas A&M
University – San Antonio, please contact the Student Counseling Center (SCC) located in Modular C,
Room 166 (Rear entrance) or call 210-784-1331 between the hours of 8:00AM and 5:00PM. All mental
health services provided by the SCC are free, confidential (as the law allows), and are not part of a
student’s academic or university record. SCC provides brief individual, couples, and group therapy,
crisis intervention, consultation, case management, and prevention services. For more information,
please visit www.tamusa.edu/studentcounseling
In a crisis situation, please walk-in to the Student Counseling Center (SCC) any time between the hours
of 8:00AM and 5:00PM to be seen by a licensed clinician. After hours, please contact UPD at 911 or
text “HOME” to 741-741 24/7/365 to connect with a trained crisis counselor. The National Suicide
Prevention hotline also offers a 24/7/365 hotline at 1-800-273-8255.
Emergency Preparedness: JagE Alert is Texas A&M University-San Antonio’s mass notification. In
the event of an emergency, such as inclement weather, students, staff and faculty, who are registered,
will have the option to receive a text message, email and/or phone call with instructions and updates. To
register or update your information visit: https://tamusa.bbcportal.com/.
More information about Emergency Preparedness and the Emergency Response Guide can be found
here: https://www.tamusa.edu/upd/index.html.
Financial Aid and Verification of Attendance: According to the following federal regulation, 34 CFR
668.21: U.S. Department of Education (DoE) Title IV regulation, a student can only receive Title IV
funds based on Title IV eligibility criteria which include class attendance. If Title IV funds are disbursed
to ineligible students (including students who fail to begin attendance), the institution must return these
funds to the U.S. DoE within 30 days of becoming aware that the student will not or has not begun
attendance. Faculty will provide the Office of Financial Aid with an electronic notification if a student
has not attended the first week of class. Any student receiving federal financial aid who does not attend
the first week of class will have their aid terminated and returned to the DoE. Please note that any
student who stops attending at any time during the semester may also need to return a portion of their
federal aid.
Jaguar Writing Center: The Jaguar Writing Center provides writing support to graduate and
undergraduate students in all three colleges. Writing tutors work with students to develop reading skills,
prepare oral presentations, and plan, draft, and revise their written assignments. The Writing Center is
currently holding all appointments digitally. Students can schedule appointments with the Writing
Center in JagWire under the student services tab. Students wanting to work in realtime with a tutor can
schedule an “Online Appointment.” Students wishing to receive asynchronous, written feedback from a
tutor can schedule an “eTutoring” appointment. More information about what services we offer, how to
make an appointment, and how to access your appointment can be found on our website at
www.tamusa.edu/Writing-Center. The Writing Center can also be reached by emailing
Meeting Basic Needs: Any student who has difficulty affording groceries or accessing sufficient food to
eat every day, or who lacks a safe and stable place to live, and believes this may affect their performance
in the course, is urged to contact the Dean of Students ([email protected]) for support. Furthermore,
please notify the professor if you are comfortable in doing so. This will enable them to provide any
resources they may possess.
QMBS 3360-600, Business Statistics II, Spring 2021, Syllabus, Dr. Anurud Rankoth 7 | P a g e
Military Affairs: Veterans and active-duty military personnel are welcomed and encouraged to
communicate, in advance if possible, and special circumstances (e.g., upcoming deployment, drill
requirements, disability accommodations). You are also encouraged to visit the Patriots’ Casa in-person
room 202, or to contact the Office of Military Affairs with any questions at [email protected] or
(210)784-1397.
Religious Observances: Texas A&M University-San Antonio recognizes the diversity of faiths
represented among the campus community and protects the rights of students, faculty, and staff to
observe religious holidays according to their tradition. Under the policy, students are provided an
opportunity to make up any examination, study, or work requirements that may be missed due to a
religious observance provided they notify their instructors before the end of the second week of classes
for regular session classes.
Respect for Diversity: We understand that our students represent diverse backgrounds and perspectives.
When we are equity-minded, we are aware of differences and inequalities and are willing to discuss
them so we can act to resolve them. The University is committed to building cultural competencies, or
the attitudes, skills, and knowledge that enable individuals and organizations to acknowledge cultural
differences and incorporate these differences in working with people from diverse cultures. Respecting
and accepting people different than you is vital to your success in the class, on campus, and as a future
professional in the global community. While working together to build this community we ask all
members to:
• Share their unique experiences, values, and beliefs.
• Be open to the views of others.
• Honor the uniqueness of their colleagues.
• Value each other’s opinions and communicate respectfully.
• Keep confidential discussions that the community has of a personal (or professional) nature.
• Use this opportunity together to discuss ways in which we can create an inclusive environment in
this course and across the A&M-San Antonio community.
The Six-Drop Rule: Students are subject to the requirements of Senate Bill (SB) 1231 passed by the
Texas Legislature in 2007. SB 1231 limits students to a maximum of six (6) non-punitive course drops
(i.e., courses a student chooses to drop) during their undergraduate careers. A non-punitive drop does
not affect the student’s GPA. However, course drops that exceed the maximum allowed by SB 1231 will
be treated as “F” grades and will impact the student’s GPA.
Statement of Harassment and Discrimination: Texas A&M University-San Antonio is committed to
the fundamental principles of academic freedom, equality of opportunity and human dignity. To fulfill
its multiple missions as an institution of higher learning, A&M-San Antonio encourages a climate that
values and nurtures collegiality, diversity, pluralism and the uniqueness of the individual within our
state, nation, and world. All decisions and actions involving students and employees should be based on
applicable law and individual merit. Texas A&M University-San Antonio, in accordance with applicable
federal and state law, prohibits discrimination, including harassment, on the basis of race, color, sex,
religion, national origin, age, disability, genetic information, veteran status, sexual orientation, gender
identity, or gender expression. Individuals who believe they have experienced harassment or
discrimination prohibited by this statement are encouraged to contact the appropriate offices within their
respective units.
Texas A&M University-San Antonio faculty are committed to helping create a safe learning
environment for all students and for the university as a whole. If you have experienced any form of sex-
or gender-based discrimination or harassment, including sexual assault, sexual harassment, domestic or
dating violence, or stalking, know that help and support are available. A&M-San Antonio has staff
QMBS 3360-600, Business Statistics II, Spring 2021, Syllabus, Dr. Anurud Rankoth 8 | P a g e
members trained to support survivors in navigating campus life, accessing health and counseling
services, providing academic and housing accommodations, and more. The university strongly
encourages all students to report any such incidents to the university. Please be aware that all A&M-San
Antonio employees (other than those designated as confidential resources such as counselors and other
healthcare providers are required to report information about such discrimination and harassment to the
university. This means that if you tell a faculty member about a situation of sexual harassment or sexual
violence, or other related misconduct, the faculty member must share that information with the
university’s Title IX Coordinator. If you wish to speak to a confidential employee who does not have
this reporting responsibility, you can contact the Student Counseling Center at (210) 784-1331, Modular
C.
Students’ Rights and Responsibilities:
The purpose of the following statement is to enumerate the essential provisions for the student freedom
and responsibility to learn at Texas A&M University-San Antonio. All students are required to follow all
policies and regulations as set forth by The Texas A&M University System. This includes the A&M-San
Antonio Student Code of Conduct.
Students’ Rights
1. A student shall have the right to participate in a free exchange of ideas, and there shall be no university rule or procedure that in any way abridges the rights of freedom of speech, expression,
petition and peaceful assembly as set forth in the U.S. Constitution.
2. Each student shall have the right to participate in all areas and activities of the university, free from any form of discrimination, including harassment, on the basis of race, color, national or
ethnic origin, religion, sex, disability, age, sexual orientation, genetic information or veteran
status in accordance with applicable federal and state laws.
3. A student has the right to personal privacy except as otherwise provided by law, and this will be observed by students and University authorities alike.
4. Each student subject to disciplinary action arising from violations of university student rules shall be assured a fundamentally fair process.
Students’ Responsibilities
1. A student has the responsibility to respect the rights and property of others, including other students, the faculty and the administration.
2. A student has the responsibility to be fully acquainted with the published University Student Rules found in the Student Handbook, Student Code of Conduct, on our website, University
Catalog and students must comply with them and the laws of the land.
3. A student has the responsibility to recognize that student actions reflect upon the individuals involved and upon the entire university community.
4. A student has the responsibility to recognize the University’s obligation to provide an environment for learning.
5. A student has the responsibility to check their university email for any updates or official university notification.
QMBS 3360-600, Business Statistics II, Spring 2021, Syllabus, Dr. Anurud Rankoth 9 | P a g e
6. We expect that students will behave in a manner that is dignified, respectful, and courteous to all people, regardless of sex, ethnic/racial origin, religious background, sexual orientation or
disability. Behaviors that infringe on the rights of another individual will not be tolerated.
Key Dates For Spring 2021 Semester
The complete academic calendar is available online:
https://www.tamusa.edu/provost/faculty/faculty-resources/fallspringsummercalendars/spring-2021.html
Jan 15 Last Day for students to withdraw to receive 100% tuition
Jan 19 Classes Begin
Mar 26 Last day to drop with an automatic "W"
Mar 29 Title IV 60% of semester (Financial Aid)
Apr 30 Last day to drop a course or withdraw from the University
May 1 Last day of Scheduled Classes
May 3, 4 Reading Days
May 5-11 Final Examinations - See your college catalog for schedule
May 11 End of Spring 2021 Semester
May 14 All grades for Spring 2021 16-week session due by Noon via JagWire
