please someone help me to solve real quick. i have send the instructions in the attachment.

1 THE NOMINAL EFFECTIVE EXCHANGE RATES (\"NEER\") & THE REAL EFFECTIVE EXCHANGE RATES (\"REER\") GROUP ASSIGNMENT PROF HARVEY PONIACHEK, SPRING 2013 DERIVE THE NEER AND THE REER BY APPLYING THE FOLOWING MODELS. THIS ASSIGNMENT SHOULD BE PERFORMED BY TEAMS OF UP TO 4 STUDENTS (BUT DEFINITELY NOT MORE), HOWEVER INDIVIDUAL WORK IS ACCEPTABLE. THE OBJECTIVE OF THIS ASSIGNMENT IS TO FAMILIARIZE YOU WITH THE APPLICATION OF FINANCIAL MODELS, INTRODUCE YOU TO MARKET DATA SOURCES, AND PROVIDE YOU WITH THE OPPORTUNITY TO INTERPRETE EMPIRICAL FINDINGS. THE ASSIGNMENT SHOULD BE SUBMITTED FOR GRADING ON THE DATE LISTED ON THE OUR SYLLABUS. A COUPLE OF ASSIGNMENTS WOULD BE SELECTED FOR PRESENTED IN CLASS. I. THE NOMINAL EFFECTIVE EXCHANGE RATE (NEER) INDEX DERIVE THE NEER BY APPLYING THE FOLOWING MODELS, FROM 1997 TO 2007, BY USING YEAR END DATA FROM THE SOURCES CITED BELOW:: NEER FC/ $, t+1 = [FC / $ n, t+1 / FC/ $ n, t] W n, t where the variable are defined as follows: t goes from 2000 to 2012, with the base year being 2001, FC/ $ n, t is the indirect quote of currency n per the $ in year t, n is the number of foreign countries (that are listed below), Wn is the export share (%) of the U.S. to each country, and sigma relates to aggregation for country n=1 to N, and each derivation for the N countries is done for each year, from 2001 TO 2012 THE WEIGHTED RATIOS ARE CREATED FOR EACH COUNTRY AND SUMMED UP FOR ALL THE n COUNTRIES TO CONSTITUTE THE INDEX FOR THE SPECIFIC YEAR. THE NEER INDEX MEASURES THE EVOLUTION OF THE $ FROM THE PERSPECTIVE OF THE U.S. MAIN TRADING PARTNERS (THAT ARE LISTED BELOW). 1. QUOTES ARE INDIRECT, FC/ $, AND FOR END OF YEAR RATES. 2. Wn MEASURES THE % SHARE OF U.S. EXPORT TO COUNTRY n, and Wn=1 3. THE $ INDEX IS SET AT 100 IN 2001, WHICH IS THE BASE YEAR. THE INDEX MEASURES THE VALUE OF THE $ FROM A FOREIGN PERSPECTIVE (FOREIGN TERMS). 1 2 4. WHEN THE INDEX IS ABOVE 100, IT IMPLIES THAT THE DOLLAR APPRECIATED; AND WHEN IT IS BELOW 100, IT IMPLIES THAT THE $ DEPRECIATED. WHEN THE INDEX FOR A SPECIFIC YEAR IS 100 IT IMPLIES THAT ON A TRADE WEIGHTED BASIS THE DOLLAR HAS NOT CHANGES, 5. FOR DIRECT QUOTES, $/FC, IF NEER >100 IT IMPLIES THE $ DEPRECIATED; AND IF NEER 100 IT IMPLIES THAT THE $ APPRECIATED ON A REAL EFFECTIVE BASIS; AND IF REER