英文数学题,指数函数, excel 表格 (求解!!急!)

Thetablebelowgivesthenumberoftextmessages(inbillions)forselectedyears.YearNumberofTex... The table below gives the number of text messages (in billions) for selected years.

Year

Number of Text Messages
(in billions)

2003 2.1
-----------------

2004 4.7

----------------

2005 9.8

------------------ -

2006 18.7

-----------------

2007 48.1

---------------------

2008 110.4

(A) Follow the directions above to find an exponential model, N(t), that predicts the number of
text messages (in billions) t years after 2000. Give the equation in both forms discussed in
class. What is the annual rate of increase? What is the continuous annual rate of increase?[Regression

For each set of data use a spreadsheet program like Excel to make a scatter plot. Make a title.
Label the axes with numbers and what they represent. Include units.
If using Excel choose "Design" then “Chart Layouts” to type in the labels.

Find the equation of the model with the spreadsheet program: graph the model and have the
formula on the graph. Excel calls the regression model a “trend line”. On Excel make the
scatterplot, then go to “Layout”, and then “Trendlines”, choose “More Trendline Options...” and
look for the type of function you want. Be sure to click the box on the bottom that says “Display
Equation on Chart”

Use the model to answer the questions associated with each set of data. ]
自己做出来的:(A)公式1:y=0.1956*2.1898^x 公式2:y=0.1956e^0.7838x

不知道对不对。
展开
尽头飞驰的少年
2013-06-18 · 超过35用户采纳过TA的回答
知道答主
回答量:79
采纳率:0%
帮助的人:93.4万
展开全部
用excel散点图(scatterplot),找到趋势线(Trendlines),选择指数(exponential model),得出指数方程y = 0.9975 e^0.7838(x - 2002).

2000年的annual rate,用线性求值,(这对于我来说难啊。。。所以采用了2003年和2004年的数据)得出,当年的增长率是2.6

continuous rate就是方程中x的系数了
臧永宜
2013-06-19
知道答主
回答量:19
采纳率:0%
帮助的人:7.9万
展开全部
Use scatterplot and find out Trendlines, Choose exponential model, and get a exponential S.U. which is "y = 0.9975 e^0.7838(x - 2002)."

Answer-------------------------------------------------------------------------------------------------
2000 years,annual rate,recoreason,and result cause 2.6

continuous rate is the S.U. of X

找的习题答案,英文的
已赞过 已踩过<
你对这个回答的评价是?
评论 收起
yangsihuahui
2013-06-18 · TA获得超过1.4万个赞
知道大有可为答主
回答量:6528
采纳率:68%
帮助的人:3117万
展开全部
y = 0.9382 e^0.7838(x - 2002)
已赞过 已踩过<
你对这个回答的评价是?
评论 收起
凝我真
2013-06-19
知道答主
回答量:8
采纳率:0%
帮助的人:5975
展开全部
  1. 用excel散点图XY(scatter)里面的scatter with data points connected by smoothed lines---会自动出现一条线,这个线不显示方程,

  2. 然后再找到趋势线(Trendlines),选择多项式(polynomial),order那里数越大越准确,出现的线就越接近之前自动出现的那条不显示方程的线。
    结果:
    y = -0.1642x5 + 3.1042x4 - 20.154x3 + 59.346x2 - 75.832x + 35.8

    order那里选折5或6方程都是上面这个。

已赞过 已踩过<
你对这个回答的评价是?
评论 收起
收起 更多回答(2)
推荐律师服务: 若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询

为你推荐:

下载百度知道APP,抢鲜体验
使用百度知道APP,立即抢鲜体验。你的手机镜头里或许有别人想知道的答案。
扫描二维码下载
×

类别

我们会通过消息、邮箱等方式尽快将举报结果通知您。

说明

0/200

提交
取消

辅 助

模 式