some one write perfect and use the excel perfect?

Portland State University

School of Business Administration

BA 301: Research and Analysis of Business Problems

Term: Summer 2014

Homework Assignment #2 Instructions

Due Date: 7/16

Format/Requirements

· Hand this in during the class session, not by email.

· Use Times New Roman, 12-point font.

· Make sure you show your name, course number, and section number on the page.

.

Questions

1) By this time you should have completed some research on your chosen company for the term paper. Provide a ½ to 1 page situation analysis that describes the current driving forces and looming uncertainties facing your company. Then, list at least four problems currently faced by the company, and characterize them using the mission critical/urgency grid discussed in class. Make sure that what you are describing is really a “problem”, i.e., “a gap between the real and the desired” or a “contradiction between principle and practice”. Choose one of these problems as the topic for your term paper and write a clear problem statement as part of this homework assignment. This is a crucial component in your term-long project, so I would recommend that you spend some time on it. It’s difficult to solve a problem if you don’t define it very well.

Special Note: Bring a separate copy of your problem statement to class for group review.

2) Find at least one “peer-reviewed” research source for your term paper. Provide evidence that it is peer-reviewed (for example – print out the page from Ulrich’s web site) and show the proper MLA citation formatting in your assignment write-up.

3) Complete the “Fun With Excel” exercise using the instructions and data file located on my web site. There are two sets of instructions – one for pre-Excel 2007 versions and one for Excel 2007. The user interface is quite different for these two versions. Follow the instructions completely, print out your results, and attach them to the homework assignment (please do not print out all of the regression data from question 1, just basic stats and the graph – be judicious and save paper). Make sure that you specifically answer the questions. This exercise requires that you have the Data Analysis package installed for Excel (Mac OS 10 doesn’t make this package available in Excel). If you don’t, you’ll need your original Microsoft discs. I suggest that you don’t wait until the last minute to complete this assignment.