Assignment1completed

docx

School

New Jersey Institute Of Technology *

*We aren’t endorsed by this school

Course

465

Subject

Information Systems

Date

Apr 3, 2024

Type

docx

Pages

Uploaded by DeaconFlag10435

IS 465 Data Analysis For Information Systems Technical Assignment 1 1. The file “assignment1_actors.xls” contains information on 66 movie stars. This data set contains five variables: a. Gender b. DomesticGross: average domestic gross of star’s last few movies (in $ million) c. ForeignGross: average foreign gross of star’s last few movies (in $ million) d. Salary: current amount the star asks for a movie (in $ million) Question 1. Using bin width of 2 (0-2, 2-4, 4-6, etc.), draw a histogram using the “salary” variable using Excel Question 2. Is there an association between a star’s domestic and foreign gross? Choose an appropriate tool to analyze this problem. Show your work in Excel, and put some brief analysis under the chart / table / picture you have in Excel

1 3 5 7 9 11 13 15 17 19 21 23 25 27 29 31 33 35 37 39 41 43 45 47 49 51 53 55 57 59 61 63 65 0 20 40 60 80 100 120 140 160 180 200 Domestic vs Foreign Gross DomesticGross ForeignGross There is an association between Domestic and Foreign Gross, as presented by this line graph. The two lines have correlated multiple times. 2. The file “Assignment1_Commute.xls” contains average time it takes for a citizen of each metropolitan area to commute to work and back home each day. Question 3. Generate a histogram for distribution of daily commute times. Are shorter or longer commute times generally more likely for these commuters? (Hint: analyze the shape of the distribution).

The histogram of commute times for metropolitan areas shows that shorter commute times are generally more common. The largest number of commuters fall into the range of times between 31 and 45 minutes, with significantly fewer commuters experiencing longer commute times. 3. The file “Assignment1_Mortgage.xls” contains annual interest rates on 30-year fixed mortgages over the years. Question 4. What conclusions can be drawn through time series analysis generated from this data?

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

1972 1973 1974 1975 1976 1977 1978 1979 1980 1981 1982 1983 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 0 2 4 6 8 10 12 14 16 18 Interest Rates on 30 year Mortgage Year Rate The time series analysis of the 30-year mortgage interest rates from 1972 to 2000 shows a peak in rates during the early 1980s, with the highest rates around 1981-1982, followed by a general downward trend into the late 1990s. The rates ended slightly higher in 2000 compared to the lowest points of the late 1990s, indicating a slight uptick at the end of the period. PLEASE USE ONE EXCEL FILE THAT CONTAINS FOUR WORKSHEETS TO ANSWER THE ABOVE QUESTIONS. EACH QUESTION SHOULD HAVE ITS OWN WORKSHEET.

Assignment1completed

Related Documents